APPS.PO_DOCUMENT_CHECKS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 3347: FROM MTL_ITEM_CATEGORIES MIC

3343: WHERE ASL1.ITEM_ID = POL.item_id
3344: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
3345: AND ASL.category_id in
3346: (SELECT MIC.category_id
3347: FROM MTL_ITEM_CATEGORIES MIC
3348: WHERE MIC.inventory_item_id = POL.item_id
3349: AND MIC.organization_id = PLL.ship_to_organization_id)
3350: AND ASL.asl_status_id = ASR.status_id
3351: AND ASR.business_rule = '1_PO_APPROVAL'

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

3373: entry is debarred either for item /Category irrespective of 'Use approved
3374: supplier flag'. This check would apply even for one time items.
3375: If supplier is debarred in any of the ASL item/category (Global/Local)
3376: (Suplier/Supplier+site) then the approval of the PO will not be allowed
3377: Need to remove the join with mtl_item_categories for one
3378: time items as there will not be any record
3379: */
3380:
3381: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');

Line 6356: FROM MTL_ITEM_CATEGORIES MIC

6352: AND ASL1.using_organization_id in
6353: (PLL.ship_to_organization_id, -1))
6354: AND ASL.category_id in
6355: (SELECT MIC.category_id
6356: FROM MTL_ITEM_CATEGORIES MIC
6357: WHERE MIC.inventory_item_id = POL.item_id
6358: AND MIC.organization_id = PLL.ship_to_organization_id)
6359: AND ASL.asl_status_id = ASR.status_id
6360: AND ASR.business_rule = '1_PO_APPROVAL'