DBA Data[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on AP_SUPPLIERS

Line 129: FROM AP_SUPPLIERS

125: END IF;
126: WHEN 'ST' THEN
127: SELECT 'ST:'||vendor_type_lookup_code
128: INTO st_code
129: FROM AP_SUPPLIERS
130: WHERE party_id = p_party_id;
131: IF (class_code = st_code) THEN
132: return_code := class_code;
133: END IF;

Line 387: , AP_SUPPLIERS AP

383: , l_evaluation_flag
384: FROM PON_BID_HEADERS PON
385: , HZ_PARTIES HZ1
386: , HZ_PARTIES HZ2
387: , AP_SUPPLIERS AP
388: WHERE PON.AUCTION_HEADER_ID = p_auction_header_id
389: AND PON.BID_NUMBER = p_bid_number
390: AND HZ1.PARTY_ID (+) = PON.EVALUATOR_ID
391: AND HZ2.PARTY_ID (+) = PON.TRADING_PARTNER_CONTACT_ID