APPS.ARP_PROCESS_FREIGHT_UTIL dependencies on AR_LOOKUPS

Line 455: lc_fob_point ar_lookups.lookup_code%TYPE;

451: , pn_SHIP_TO_CUSTOMER_ID IN NUMBER
452: , pn_BILL_TO_CUSTOMER_ID IN NUMBER
453: , pc_fob_point OUT NOCOPY VARCHAR2
454: , pc_fob_point_name OUT NOCOPY VARCHAR2) IS
455: lc_fob_point ar_lookups.lookup_code%TYPE;
456: lc_fob_point_name ar_lookups.meaning%TYPE;
457:
458: BEGIN
459: IF (pn_SHIP_TO_SITE_USE_ID IS NOT NULL)

Line 456: lc_fob_point_name ar_lookups.meaning%TYPE;

452: , pn_BILL_TO_CUSTOMER_ID IN NUMBER
453: , pc_fob_point OUT NOCOPY VARCHAR2
454: , pc_fob_point_name OUT NOCOPY VARCHAR2) IS
455: lc_fob_point ar_lookups.lookup_code%TYPE;
456: lc_fob_point_name ar_lookups.meaning%TYPE;
457:
458: BEGIN
459: IF (pn_SHIP_TO_SITE_USE_ID IS NOT NULL)
460: THEN

Line 467: FROM AR_LOOKUPS L

463: , l.MEANING
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

Line 504: FROM AR_LOOKUPS L

500: , l.MEANING
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

Line 542: FROM AR_LOOKUPS L

538: , l.MEANING
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

Line 575: FROM AR_LOOKUPS L

571: , l.MEANING
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