APPS.PON_ATTR_MAPPING dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 705: /* ORG_ID in PON_AUCTION_ITEM_PRICES_ALL is only the OU id, and the actual INVENTORY_ORGANIZATION_ID is in FINANCIALS_SYSTEM_PARAMS_ALL */

701: , l_user_data_level_name
702: FROM EGO_DATA_LEVEL_VL
703: WHERE DATA_LEVEL_ID = item_ag_dl_rec.data_level_id;
704:
705: /* ORG_ID in PON_AUCTION_ITEM_PRICES_ALL is only the OU id, and the actual INVENTORY_ORGANIZATION_ID is in FINANCIALS_SYSTEM_PARAMS_ALL */
706: SELECT ITEM_ID
707: , ITEM_NUMBER
708: , F.INVENTORY_ORGANIZATION_ID
709: INTO l_item_id

Line 713: , FINANCIALS_SYSTEM_PARAMS_ALL F

709: INTO l_item_id
710: , l_item_number
711: , l_org_id
712: FROM PON_AUCTION_ITEM_PRICES_ALL P
713: , FINANCIALS_SYSTEM_PARAMS_ALL F
714: WHERE P.AUCTION_HEADER_ID = p_auction_header_id
715: AND P.LINE_NUMBER = item_ag_dl_rec.line_number
716: AND P.ORG_ID = F.ORG_ID;
717:

Line 976: , financials_system_params_all f

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
979: AND item.line_number = price.line_number
980: AND bid.auction_header_id = price.auction_header_id