APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_CUST_ACCOUNTS

Line 105: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

101: ATTRIBUTE20)
102: FROM HZ_ORIG_SYS_REFERENCES
103: WHERE
104: OWNER_TABLE_ID = RELATED_CUST_ACCOUNT_ID
105: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
107: FROM HZ_CUST_ACCT_RELATE
108: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID;
109:

Line 601: Customer Account Y N HZ_CUST_ACCOUNTS

597: returns all records for the particular contact from these TCA entity tables.
598:
599: Embedded TCA Entity Mandatory Multiple TCA Table Entities
600:
601: Customer Account Y N HZ_CUST_ACCOUNTS
602: Account Relationship N Y HZ_CUST_ACCT_RELATE
603: Bank Account Use N Y Owned by Payments team
604: Payment Method N N Owned by AR team
605:

Line 629: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),

625: NULL, -- COMMON_OBJ_ID
626: CA.CUST_ACCOUNT_ID,
627: NULL, --ORIG_SYSTEM,
628: NULL, --ORIG_SYSTEM_REFERENCE,
629: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),
630: CA.PARTY_ID,
631: CA.ACCOUNT_NUMBER,
632: CA.ATTRIBUTE_CATEGORY,
633: CA.ATTRIBUTE1,

Line 776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

772: ATTRIBUTE20)
773: FROM HZ_ORIG_SYS_REFERENCES OSR
774: WHERE
775: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),

Line 838: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA

834: FROM RA_CUST_RECEIPT_METHODS CRM
835: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID
836: AND ROWNUM = 1)
837: )
838: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA
839: WHERE P.PARTY_ID = CA.PARTY_ID
840: AND ((P_CUST_ACCT_ID IS NULL AND P.PARTY_ID = P_PARENT_ID)
841: OR (P_CUST_ACCT_ID IS NOT NULL AND CA.CUST_ACCOUNT_ID = P_CUST_ACCT_ID));
842:

Line 1061: Customer Account Y N HZ_CUST_ACCOUNTS

1057: returns all records for the particular contact from these TCA entity tables.
1058:
1059: Embedded TCA Entity Mandatory Multiple TCA Table Entities
1060:
1061: Customer Account Y N HZ_CUST_ACCOUNTS
1062: Account Relationship N Y HZ_CUST_ACCT_RELATE
1063: Bank Account Use N Y Owned by Payments team
1064: Payment Method N N Owned by AR team
1065:

Line 1089: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),

1085: NULL, -- COMMON_OBJ_ID
1086: CA.CUST_ACCOUNT_ID,
1087: NULL, --ORIG_SYSTEM,
1088: NULL, --ORIG_SYSTEM_REFERENCE,
1089: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),
1090: CA.PARTY_ID,
1091: CA.ACCOUNT_NUMBER,
1092: CA.ATTRIBUTE_CATEGORY,
1093: CA.ATTRIBUTE1,

Line 1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

1232: ATTRIBUTE20)
1233: FROM HZ_ORIG_SYS_REFERENCES OSR
1234: WHERE
1235: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),

Line 1297: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA

1293: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1294: FROM RA_CUST_RECEIPT_METHODS CRM
1295: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL )
1296: )
1297: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA
1298: WHERE P.PARTY_ID = CA.PARTY_ID
1299: AND ((P_CUST_ACCT_ID IS NULL AND P.PARTY_ID = P_PARENT_ID)
1300: OR (P_CUST_ACCT_ID IS NOT NULL AND CA.CUST_ACCOUNT_ID = P_CUST_ACCT_ID));
1301: