DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on MTL_ITEM_CATEGORIES

Line 3114: FROM MTL_ITEM_CATEGORIES MIC

3110: WHERE ASL1.ITEM_ID = POL.item_id
3111: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
3112: AND ASL.category_id in
3113: (SELECT MIC.category_id
3114: FROM MTL_ITEM_CATEGORIES MIC
3115: WHERE MIC.inventory_item_id = POL.item_id
3116: AND MIC.organization_id = PLL.ship_to_organization_id)
3117: AND ASL.asl_status_id = ASR.status_id
3118: AND ASR.business_rule = '1_PO_APPROVAL'

Line 3183: FROM MTL_ITEM_CATEGORIES MIC

3179: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3180: AND ASL.item_id is NULL
3181: AND ASL.category_id in
3182: (SELECT MIC.category_id
3183: FROM MTL_ITEM_CATEGORIES MIC
3184: WHERE MIC.inventory_item_id = POL.item_id
3185: AND MIC.organization_id = PLL.ship_to_organization_id)
3186: AND ASL.asl_status_id = ASR.status_id
3187: AND ASR.business_rule = '1_PO_APPROVAL'