DBA Data[Home] [Help]

APPS.ARP_PROCESS_FREIGHT_UTIL dependencies on HZ_CUST_SITE_USES

Line 468: , HZ_CUST_SITE_USES site_uses

464: INTO
465: lc_fob_point
466: , lc_fob_point_name
467: FROM AR_LOOKUPS L
468: , HZ_CUST_SITE_USES site_uses
469: WHERE site_uses.SITE_USE_ID = pn_SHIP_TO_SITE_USE_ID
470: AND L.LOOKUP_TYPE = 'FOB'
471: AND L.LOOKUP_CODE = site_uses.FOB_POINT
472: AND L.ENABLED_FLAG = 'Y'

Line 505: , HZ_CUST_SITE_USES site_uses

501: INTO
502: lc_fob_point
503: , lc_fob_point_name
504: FROM AR_LOOKUPS L
505: , HZ_CUST_SITE_USES site_uses
506: WHERE site_uses.SITE_USE_ID = pn_BILL_TO_SITE_USE_ID
507: AND L.LOOKUP_TYPE = 'FOB'
508: AND L.LOOKUP_CODE = site_uses.FOB_POINT
509: AND L.ENABLED_FLAG = 'Y'