1. Tables and Views for Project Management
  2. PJB_XLA_SOLDTO_CUST_ACCT_V

PJB_XLA_SOLDTO_CUST_ACCT_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

SOLD_TO_CUSTOMER_ID

SOLD_TO_CUSTOMER_NAME

SOLD_TO_CUSTOMER_NUMBER

SOLD_ORG_PROFILE_ATTR_CAT

SOLD_ORG_PROFILE_ATTR1

SOLD_ORG_PROFILE_ATTR2

SOLD_ORG_PROFILE_ATTR3

SOLD_ORG_PROFILE_ATTR4

SOLD_ORG_PROFILE_ATTR5

SOLD_ORG_PROFILE_ATTR6

SOLD_ORG_PROFILE_ATTR7

SOLD_ORG_PROFILE_ATTR8

SOLD_ORG_PROFILE_ATTR9

SOLD_ORG_PROFILE_ATTR10

SOLD_ORG_PROFILE_ATTR11

SOLD_ORG_PROFILE_ATTR12

SOLD_ORG_PROFILE_ATTR13

SOLD_ORG_PROFILE_ATTR14

SOLD_ORG_PROFILE_ATTR15

SOLD_ORG_PROFILE_ATTR16

SOLD_ORG_PROFILE_ATTR17

SOLD_ORG_PROFILE_ATTR18

SOLD_ORG_PROFILE_ATTR19

SOLD_ORG_PROFILE_ATTR20

SOLD_ORG_PROFILE_ATTR21

SOLD_ORG_PROFILE_ATTR22

SOLD_ORG_PROFILE_ATTR23

SOLD_ORG_PROFILE_ATTR24

SOLD_ORG_PROFILE_ATTR25

SOLD_ORG_PROFILE_ATTR26

SOLD_ORG_PROFILE_ATTR27

SOLD_ORG_PROFILE_ATTR28

SOLD_ORG_PROFILE_ATTR29

SOLD_ORG_PROFILE_ATTR30

SOLD_ORG_PROFILE_ATTRNUM1

SOLD_ORG_PROFILE_ATTRNUM2

SOLD_ORG_PROFILE_ATTRNUM3

SOLD_ORG_PROFILE_ATTRNUM4

SOLD_ORG_PROFILE_ATTRNUM5

SOLD_ORG_PROFILE_ATTRNUM6

SOLD_ORG_PROFILE_ATTRNUM7

SOLD_ORG_PROFILE_ATTRNUM8

SOLD_ORG_PROFILE_ATTRNUM9

SOLD_ORG_PROFILE_ATTRNUM10

SOLD_ORG_PROFILE_ATTRNUM11

SOLD_ORG_PROFILE_ATTRNUM12

SOLD_ORG_PROFILE_ATTRDATE1

SOLD_ORG_PROFILE_ATTRDATE2

SOLD_ORG_PROFILE_ATTRDATE3

SOLD_ORG_PROFILE_ATTRDATE4

SOLD_ORG_PROFILE_ATTRDATE5

SOLD_ORG_PROFILE_ATTRDATE6

SOLD_ORG_PROFILE_ATTRDATE7

SOLD_ORG_PROFILE_ATTRDATE8

SOLD_ORG_PROFILE_ATTRDATE9

SOLD_ORG_PROFILE_ATTRDATE10

SOLD_ORG_PROFILE_ATTRDATE11

SOLD_ORG_PROFILE_ATTRDATE12

Query

SQL_Statement

SELECT

CustAcct.Cust_ACCOUNT_ID SOLD_TO_CUSTOMER_ID,

CustAcct.Cust_ACCOUNT_ID SOLD_TO_CUSTOMER_NAME,

CustAcct.ACCOUNT_NUMBER SOLD_TO_CUSTOMER_NUMBER,

OrgProfile.ATTRIBUTE_CATEGORY SOLD_ORG_PROFILE_ATTR_CAT,

OrgProfile.ATTRIBUTE1 SOLD_ORG_PROFILE_ATTR1,

OrgProfile.ATTRIBUTE2 SOLD_ORG_PROFILE_ATTR2,

OrgProfile.ATTRIBUTE3 SOLD_ORG_PROFILE_ATTR3,

OrgProfile.ATTRIBUTE4 SOLD_ORG_PROFILE_ATTR4,

OrgProfile.ATTRIBUTE5 SOLD_ORG_PROFILE_ATTR5,

OrgProfile.ATTRIBUTE6 SOLD_ORG_PROFILE_ATTR6,

OrgProfile.ATTRIBUTE7 SOLD_ORG_PROFILE_ATTR7,

OrgProfile.ATTRIBUTE8 SOLD_ORG_PROFILE_ATTR8,

OrgProfile.ATTRIBUTE9 SOLD_ORG_PROFILE_ATTR9,

OrgProfile.ATTRIBUTE10 SOLD_ORG_PROFILE_ATTR10,

OrgProfile.ATTRIBUTE11 SOLD_ORG_PROFILE_ATTR11,

OrgProfile.ATTRIBUTE12 SOLD_ORG_PROFILE_ATTR12,

OrgProfile.ATTRIBUTE13 SOLD_ORG_PROFILE_ATTR13,

OrgProfile.ATTRIBUTE14 SOLD_ORG_PROFILE_ATTR14,

OrgProfile.ATTRIBUTE15 SOLD_ORG_PROFILE_ATTR15,

OrgProfile.ATTRIBUTE16 SOLD_ORG_PROFILE_ATTR16,

OrgProfile.ATTRIBUTE17 SOLD_ORG_PROFILE_ATTR17,

OrgProfile.ATTRIBUTE18 SOLD_ORG_PROFILE_ATTR18,

OrgProfile.ATTRIBUTE19 SOLD_ORG_PROFILE_ATTR19,

OrgProfile.ATTRIBUTE20 SOLD_ORG_PROFILE_ATTR20,

OrgProfile.ATTRIBUTE21 SOLD_ORG_PROFILE_ATTR21,

OrgProfile.ATTRIBUTE22 SOLD_ORG_PROFILE_ATTR22,

OrgProfile.ATTRIBUTE23 SOLD_ORG_PROFILE_ATTR23,

OrgProfile.ATTRIBUTE24 SOLD_ORG_PROFILE_ATTR24,

OrgProfile.ATTRIBUTE25 SOLD_ORG_PROFILE_ATTR25,

OrgProfile.ATTRIBUTE26 SOLD_ORG_PROFILE_ATTR26,

OrgProfile.ATTRIBUTE27 SOLD_ORG_PROFILE_ATTR27,

OrgProfile.ATTRIBUTE28 SOLD_ORG_PROFILE_ATTR28,

OrgProfile.ATTRIBUTE29 SOLD_ORG_PROFILE_ATTR29,

OrgProfile.ATTRIBUTE30 SOLD_ORG_PROFILE_ATTR30,

OrgProfile.ATTRIBUTE_NUMBER1 SOLD_ORG_PROFILE_ATTRNUM1,

OrgProfile.ATTRIBUTE_NUMBER2 SOLD_ORG_PROFILE_ATTRNUM2,

OrgProfile.ATTRIBUTE_NUMBER3 SOLD_ORG_PROFILE_ATTRNUM3,

OrgProfile.ATTRIBUTE_NUMBER4 SOLD_ORG_PROFILE_ATTRNUM4,

OrgProfile.ATTRIBUTE_NUMBER5 SOLD_ORG_PROFILE_ATTRNUM5,

OrgProfile.ATTRIBUTE_NUMBER6 SOLD_ORG_PROFILE_ATTRNUM6,

OrgProfile.ATTRIBUTE_NUMBER7 SOLD_ORG_PROFILE_ATTRNUM7,

OrgProfile.ATTRIBUTE_NUMBER8 SOLD_ORG_PROFILE_ATTRNUM8,

OrgProfile.ATTRIBUTE_NUMBER9 SOLD_ORG_PROFILE_ATTRNUM9,

OrgProfile.ATTRIBUTE_NUMBER10 SOLD_ORG_PROFILE_ATTRNUM10,

OrgProfile.ATTRIBUTE_NUMBER11 SOLD_ORG_PROFILE_ATTRNUM11,

OrgProfile.ATTRIBUTE_NUMBER12 SOLD_ORG_PROFILE_ATTRNUM12,

OrgProfile.ATTRIBUTE_DATE1 SOLD_ORG_PROFILE_ATTRDATE1,

OrgProfile.ATTRIBUTE_DATE2 SOLD_ORG_PROFILE_ATTRDATE2,

OrgProfile.ATTRIBUTE_DATE3 SOLD_ORG_PROFILE_ATTRDATE3,

OrgProfile.ATTRIBUTE_DATE4 SOLD_ORG_PROFILE_ATTRDATE4,

OrgProfile.ATTRIBUTE_DATE5 SOLD_ORG_PROFILE_ATTRDATE5,

OrgProfile.ATTRIBUTE_DATE6 SOLD_ORG_PROFILE_ATTRDATE6,

OrgProfile.ATTRIBUTE_DATE7 SOLD_ORG_PROFILE_ATTRDATE7,

OrgProfile.ATTRIBUTE_DATE8 SOLD_ORG_PROFILE_ATTRDATE8,

OrgProfile.ATTRIBUTE_DATE9 SOLD_ORG_PROFILE_ATTRDATE9,

OrgProfile.ATTRIBUTE_DATE10 SOLD_ORG_PROFILE_ATTRDATE10,

OrgProfile.ATTRIBUTE_DATE11 SOLD_ORG_PROFILE_ATTRDATE11,

OrgProfile.ATTRIBUTE_DATE12 SOLD_ORG_PROFILE_ATTRDATE12

FROM

HZ_cust_accounts custAcct,

HZ_ORGANIZATION_PROFILES OrgProfile,

HZ_PARTIES CustParty

WHERE

CustAcct.party_id = CustParty.party_id

AND CustParty.party_id = OrgProfile.party_id

AND SYSDATE BETWEEN OrgProfile.EFFECTIVE_START_DATE AND NVL (OrgProfile.EFFECTIVE_END_DATE, SYSDATE + 1)