APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_SITE_USES

Line 509: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'

505: ATTRIBUTE19,
506: ATTRIBUTE20)
507: FROM HZ_ORIG_SYS_REFERENCES OSR
508: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
509: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
510: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
511: NULL, --HZ_CUSTOMER_PROFILE_BO
512: CAST(MULTISET (
513: SELECT HZ_BANK_ACCT_USE_OBJ(

Line 568: FROM HZ_CUST_SITE_USES CSU

564: FROM RA_CUST_RECEIPT_METHODS CRM
565: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID
566: AND ROWNUM = 1)
567: )
568: FROM HZ_CUST_SITE_USES CSU
569: WHERE CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID;
570:
571: BEGIN
572:

Line 742: structures:HZ_CUST_SITE_USES_ALL,Customer

738:
739: Party Site Y N get_party_site_bo
740: Customer Account Site Contact N Y get_cust_acct_contact_bo
741: Customer Account Site Use N Y Business Structure. Included entities and
742: structures:HZ_CUST_SITE_USES_ALL,Customer
743: Profile (Business Structure)
744:
745:
746: To retrieve the appropriate embedded entities within the 'Organization Contact' business object, the Get procedure returns

Line 1255: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'

1251: ATTRIBUTE19,
1252: ATTRIBUTE20)
1253: FROM HZ_ORIG_SYS_REFERENCES OSR
1254: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
1255: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
1256: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1257: NULL, --HZ_CUSTOMER_PROFILE_BO
1258: CAST(MULTISET (
1259: SELECT HZ_BANK_ACCT_USE_OBJ(

Line 1314: FROM HZ_CUST_SITE_USES CSU

1310: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1311: FROM RA_CUST_RECEIPT_METHODS CRM
1312: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL)
1313: )
1314: FROM HZ_CUST_SITE_USES CSU
1315: WHERE CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID;
1316:
1317: BEGIN
1318:

Line 1488: structures:HZ_CUST_SITE_USES_ALL,Customer

1484:
1485: Party Site Y N get_party_site_bo
1486: Customer Account Site Contact N Y get_cust_acct_contact_bo
1487: Customer Account Site Use N Y Business Structure. Included entities and
1488: structures:HZ_CUST_SITE_USES_ALL,Customer
1489: Profile (Business Structure)
1490:
1491:
1492: To retrieve the appropriate embedded entities within the 'Organization Contact' business object, the Get procedure returns