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'
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'