DBA Data[Home] [Help]

APPS.FV_SF1080_TRANSACTION dependencies on HZ_PARTY_SITES

Line 258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp

254: hzl.state cust_state,
255: hzl.postal_code cust_postal_code
256: FROM RA_CUSTOMER_TRX rct,
257: hz_locations hzl, hz_cust_acct_sites hzcas,
258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp
259: WHERE rct.set_of_books_id = parm_set_of_books_id
260: AND rct.bill_to_customer_id = hzca.cust_account_id
261: AND hzca.cust_Account_id = hzcas.cust_account_id
262: AND hzp.party_id = hzca.party_id

Line 360: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps

356: BEGIN
357: SELECT ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,POSTAL_CODE
358: INTO REMIT_ADDRESS1,REMIT_ADDRESS2,REMIT_ADDRESS3,REMIT_ADDRESS4,
359: REMIT_CITY,REMIT_STATE,REMIT_POSTAL_CODE
360: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps
361: WHERE hzcas.cust_Acct_site_id =
362: TS_REPORT_HEADER_ENTRY.REMIT_TO_ADDRESS_ID
363: AND hzcas.party_site_id = hzps.party_site_id
364: AND hzps.location_id = hzl.location_id;