APPS.PON_SOURCING_OPENAPI_GRP dependencies on MTL_CATEGORIES_KFV

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

1117: 0, -- last_amendment_update
1118: sysdate, -- modified_date
1119: item_description, -- item_description
1120: pon_auc_items_interface.category_id, -- category_id
1121: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1122: pon_auc_items_interface.ip_category_id, -- ip_category_id
1123: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1124: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1125: 0, -- number_of_bids

Line 1161: mtl_categories_kfv

1157: 'LINE', -- Group Type
1158: interface_line_number, -- document_disp_line_number
1159: interface_line_number -- sub_line_sequence_number
1160: FROM pon_auc_items_interface,
1161: mtl_categories_kfv
1162: WHERE interface_auction_header_id = p_interface_id
1163: AND interface_line_number >= l_batch_start
1164: AND interface_line_number <= l_batch_end
1165: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;

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

1161: mtl_categories_kfv
1162: WHERE interface_auction_header_id = p_interface_id
1163: AND interface_line_number >= l_batch_start
1164: AND interface_line_number <= l_batch_end
1165: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;
1166:
1167: -- Update the shipments flag based on if their are shipments
1168:
1169: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then