APPS.PO_DOCUMENT_CHECKS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 5184: FROM MTL_ITEM_CATEGORIES MIC

5180: WHERE ASL1.ITEM_ID = POL.item_id
5181: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
5182: AND ASL.category_id in
5183: (SELECT MIC.category_id
5184: FROM MTL_ITEM_CATEGORIES MIC
5185: WHERE MIC.inventory_item_id = POL.item_id
5186: AND MIC.organization_id = PLL.ship_to_organization_id)
5187: AND ASL.asl_status_id = ASR.status_id
5188: AND ASR.business_rule = '1_PO_APPROVAL'

Line 5214: Need to remove the join with mtl_item_categories for one

5210: entry is debarred either for item /Category irrespective of 'Use approved
5211: supplier flag'. This check would apply even for one time items.
5212: If supplier is debarred in any of the ASL item/category (Global/Local)
5213: (Suplier/Supplier+site) then the approval of the PO will not be allowed
5214: Need to remove the join with mtl_item_categories for one
5215: time items as there will not be any record
5216: */
5217:
5218: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');

Line 9010: FROM MTL_ITEM_CATEGORIES MIC

9006: AND ASL1.using_organization_id in
9007: (PLL.ship_to_organization_id, -1))
9008: AND ASL.category_id in
9009: (SELECT MIC.category_id
9010: FROM MTL_ITEM_CATEGORIES MIC
9011: WHERE MIC.inventory_item_id = POL.item_id
9012: AND MIC.organization_id = PLL.ship_to_organization_id)
9013: AND ASL.asl_status_id = ASR.status_id
9014: AND ASR.business_rule = '1_PO_APPROVAL'