APPS.PON_SOURCING_OPENAPI_GRP dependencies on MTL_CATEGORIES_KFV

Line 1384: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table

1380: 0, -- last_amendment_update
1381: sysdate, -- modified_date
1382: item_description, -- item_description
1383: pon_auc_items_interface.category_id, -- category_id
1384: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1385: pon_auc_items_interface.ip_category_id, -- ip_category_id
1386: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1387: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1388: 0, -- number_of_bids

Line 1438: mtl_categories_kfv

1434: CLM_CONTRACT_TYPE, -- bug 9914034
1435: CLM_COST_CONSTRAINT,
1436: CLM_IDC_TYPE
1437: FROM pon_auc_items_interface,
1438: mtl_categories_kfv
1439: WHERE interface_auction_header_id = p_interface_id
1440: AND interface_line_number >= l_batch_start
1441: AND interface_line_number <= l_batch_end
1442: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;

Line 1442: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;

1438: mtl_categories_kfv
1439: WHERE interface_auction_header_id = p_interface_id
1440: AND interface_line_number >= l_batch_start
1441: AND interface_line_number <= l_batch_end
1442: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;
1443:
1444:
1445:
1446: