DBA Data[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on PON_BID_ITEM_PRICES

Line 731: FROM PON_BID_ITEM_PRICES

727:
728: IF (item_ag_dl_rec.data_level_id = 43105) THEN
729: SELECT SHIP_TO_LOCATION_ID
730: INTO l_ship_to_org_id
731: FROM PON_BID_ITEM_PRICES
732: WHERE AUCTION_HEADER_ID = p_auction_header_id
733: AND BID_NUMBER = p_bid_number
734: AND LINE_NUMBER = item_ag_dl_rec.line_number;
735:

Line 974: , pon_bid_item_prices item

970: , item.approval_status
971: , f.inventory_organization_id
972: , NVL(hl.inventory_organization_id, -1) ship_to_org_id
973: FROM pon_bid_headers bid
974: , pon_bid_item_prices item
975: , pon_auction_item_prices_all price
976: , financials_system_params_all f
977: , hr_locations_all hl
978: WHERE bid.bid_number = item.bid_number