DBA Data[Home] [Help]

APPS.ARP_PROCESS_FREIGHT_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 543: , hz_cust_accounts cust_acct

539: INTO
540: lc_fob_point
541: , lc_fob_point_name
542: FROM AR_LOOKUPS L
543: , hz_cust_accounts cust_acct
544: WHERE cust_acct.cust_account_id = pn_SHIP_TO_CUSTOMER_ID
545: AND L.LOOKUP_TYPE = 'FOB'
546: AND L.LOOKUP_CODE = cust_acct.FOB_POINT
547: AND L.ENABLED_FLAG = 'Y'

Line 576: , hz_cust_accounts cust_acct

572: INTO
573: lc_fob_point
574: , lc_fob_point_name
575: FROM AR_LOOKUPS L
576: , hz_cust_accounts cust_acct
577: WHERE cust_acct.cust_account_id= pn_BILL_TO_CUSTOMER_ID
578: AND L.LOOKUP_TYPE = 'FOB'
579: AND L.LOOKUP_CODE = cust_acct.FOB_POINT
580: AND L.ENABLED_FLAG = 'Y'