1. Tables and Views for Project Management
  2. PJB_XLA_BILLTO_CUST_ACCT_V

PJB_XLA_BILLTO_CUST_ACCT_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

CUSTOMER_ID

BILL_ORG_PROFILE_ATTR_CAT

BILL_ORG_PROFILE_ATTR1

BILL_ORG_PROFILE_ATTR2

BILL_ORG_PROFILE_ATTR3

BILL_ORG_PROFILE_ATTR4

BILL_ORG_PROFILE_ATTR5

BILL_ORG_PROFILE_ATTR6

BILL_ORG_PROFILE_ATTR7

BILL_ORG_PROFILE_ATTR8

BILL_ORG_PROFILE_ATTR9

BILL_ORG_PROFILE_ATTR10

BILL_ORG_PROFILE_ATTR11

BILL_ORG_PROFILE_ATTR12

BILL_ORG_PROFILE_ATTR13

BILL_ORG_PROFILE_ATTR14

BILL_ORG_PROFILE_ATTR15

BILL_ORG_PROFILE_ATTR16

BILL_ORG_PROFILE_ATTR17

BILL_ORG_PROFILE_ATTR18

BILL_ORG_PROFILE_ATTR19

BILL_ORG_PROFILE_ATTR20

BILL_ORG_PROFILE_ATTR21

BILL_ORG_PROFILE_ATTR22

BILL_ORG_PROFILE_ATTR23

BILL_ORG_PROFILE_ATTR24

BILL_ORG_PROFILE_ATTR25

BILL_ORG_PROFILE_ATTR26

BILL_ORG_PROFILE_ATTR27

BILL_ORG_PROFILE_ATTR28

BILL_ORG_PROFILE_ATTR29

BILL_ORG_PROFILE_ATTR30

BILL_ORG_PROFILE_ATTRNUM1

BILL_ORG_PROFILE_ATTRNUM2

BILL_ORG_PROFILE_ATTRNUM3

BILL_ORG_PROFILE_ATTRNUM4

BILL_ORG_PROFILE_ATTRNUM5

BILL_ORG_PROFILE_ATTRNUM6

BILL_ORG_PROFILE_ATTRNUM7

BILL_ORG_PROFILE_ATTRNUM8

BILL_ORG_PROFILE_ATTRNUM9

BILL_ORG_PROFILE_ATTRNUM10

BILL_ORG_PROFILE_ATTRNUM11

BILL_ORG_PROFILE_ATTRNUM12

BILL_ORG_PROFILE_ATTRDATE1

BILL_ORG_PROFILE_ATTRDATE2

BILL_ORG_PROFILE_ATTRDATE3

BILL_ORG_PROFILE_ATTRDATE4

BILL_ORG_PROFILE_ATTRDATE5

BILL_ORG_PROFILE_ATTRDATE6

BILL_ORG_PROFILE_ATTRDATE7

BILL_ORG_PROFILE_ATTRDATE8

BILL_ORG_PROFILE_ATTRDATE9

BILL_ORG_PROFILE_ATTRDATE10

BILL_ORG_PROFILE_ATTRDATE11

BILL_ORG_PROFILE_ATTRDATE12

Query

SQL_Statement

SELECT

CustAcct.Cust_ACCOUNT_ID CUSTOMER_ID,

OrgProfile.ATTRIBUTE_CATEGORY BILL_ORG_PROFILE_ATTR_CAT,

OrgProfile.ATTRIBUTE1 BILL_ORG_PROFILE_ATTR1,

OrgProfile.ATTRIBUTE2 BILL_ORG_PROFILE_ATTR2,

OrgProfile.ATTRIBUTE3 BILL_ORG_PROFILE_ATTR3,

OrgProfile.ATTRIBUTE4 BILL_ORG_PROFILE_ATTR4,

OrgProfile.ATTRIBUTE5 BILL_ORG_PROFILE_ATTR5,

OrgProfile.ATTRIBUTE6 BILL_ORG_PROFILE_ATTR6,

OrgProfile.ATTRIBUTE7 BILL_ORG_PROFILE_ATTR7,

OrgProfile.ATTRIBUTE8 BILL_ORG_PROFILE_ATTR8,

OrgProfile.ATTRIBUTE9 BILL_ORG_PROFILE_ATTR9,

OrgProfile.ATTRIBUTE10 BILL_ORG_PROFILE_ATTR10,

OrgProfile.ATTRIBUTE11 BILL_ORG_PROFILE_ATTR11,

OrgProfile.ATTRIBUTE12 BILL_ORG_PROFILE_ATTR12,

OrgProfile.ATTRIBUTE13 BILL_ORG_PROFILE_ATTR13,

OrgProfile.ATTRIBUTE14 BILL_ORG_PROFILE_ATTR14,

OrgProfile.ATTRIBUTE15 BILL_ORG_PROFILE_ATTR15,

OrgProfile.ATTRIBUTE16 BILL_ORG_PROFILE_ATTR16,

OrgProfile.ATTRIBUTE17 BILL_ORG_PROFILE_ATTR17,

OrgProfile.ATTRIBUTE18 BILL_ORG_PROFILE_ATTR18,

OrgProfile.ATTRIBUTE19 BILL_ORG_PROFILE_ATTR19,

OrgProfile.ATTRIBUTE20 BILL_ORG_PROFILE_ATTR20,

OrgProfile.ATTRIBUTE21 BILL_ORG_PROFILE_ATTR21,

OrgProfile.ATTRIBUTE22 BILL_ORG_PROFILE_ATTR22,

OrgProfile.ATTRIBUTE23 BILL_ORG_PROFILE_ATTR23,

OrgProfile.ATTRIBUTE24 BILL_ORG_PROFILE_ATTR24,

OrgProfile.ATTRIBUTE25 BILL_ORG_PROFILE_ATTR25,

OrgProfile.ATTRIBUTE26 BILL_ORG_PROFILE_ATTR26,

OrgProfile.ATTRIBUTE27 BILL_ORG_PROFILE_ATTR27,

OrgProfile.ATTRIBUTE28 BILL_ORG_PROFILE_ATTR28,

OrgProfile.ATTRIBUTE29 BILL_ORG_PROFILE_ATTR29,

OrgProfile.ATTRIBUTE30 BILL_ORG_PROFILE_ATTR30,

OrgProfile.ATTRIBUTE_NUMBER1 BILL_ORG_PROFILE_ATTRNUM1,

OrgProfile.ATTRIBUTE_NUMBER2 BILL_ORG_PROFILE_ATTRNUM2,

OrgProfile.ATTRIBUTE_NUMBER3 BILL_ORG_PROFILE_ATTRNUM3,

OrgProfile.ATTRIBUTE_NUMBER4 BILL_ORG_PROFILE_ATTRNUM4,

OrgProfile.ATTRIBUTE_NUMBER5 BILL_ORG_PROFILE_ATTRNUM5,

OrgProfile.ATTRIBUTE_NUMBER6 BILL_ORG_PROFILE_ATTRNUM6,

OrgProfile.ATTRIBUTE_NUMBER7 BILL_ORG_PROFILE_ATTRNUM7,

OrgProfile.ATTRIBUTE_NUMBER8 BILL_ORG_PROFILE_ATTRNUM8,

OrgProfile.ATTRIBUTE_NUMBER9 BILL_ORG_PROFILE_ATTRNUM9,

OrgProfile.ATTRIBUTE_NUMBER10 BILL_ORG_PROFILE_ATTRNUM10,

OrgProfile.ATTRIBUTE_NUMBER11 BILL_ORG_PROFILE_ATTRNUM11,

OrgProfile.ATTRIBUTE_NUMBER12 BILL_ORG_PROFILE_ATTRNUM12,

OrgProfile.ATTRIBUTE_DATE1 BILL_ORG_PROFILE_ATTRDATE1,

OrgProfile.ATTRIBUTE_DATE2 BILL_ORG_PROFILE_ATTRDATE2,

OrgProfile.ATTRIBUTE_DATE3 BILL_ORG_PROFILE_ATTRDATE3,

OrgProfile.ATTRIBUTE_DATE4 BILL_ORG_PROFILE_ATTRDATE4,

OrgProfile.ATTRIBUTE_DATE5 BILL_ORG_PROFILE_ATTRDATE5,

OrgProfile.ATTRIBUTE_DATE6 BILL_ORG_PROFILE_ATTRDATE6,

OrgProfile.ATTRIBUTE_DATE7 BILL_ORG_PROFILE_ATTRDATE7,

OrgProfile.ATTRIBUTE_DATE8 BILL_ORG_PROFILE_ATTRDATE8,

OrgProfile.ATTRIBUTE_DATE9 BILL_ORG_PROFILE_ATTRDATE9,

OrgProfile.ATTRIBUTE_DATE10 BILL_ORG_PROFILE_ATTRDATE10,

OrgProfile.ATTRIBUTE_DATE11 BILL_ORG_PROFILE_ATTRDATE11,

OrgProfile.ATTRIBUTE_DATE12 BILL_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)