DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on MTL_ITEM_CATEGORIES

Line 3168: FROM MTL_ITEM_CATEGORIES MIC

3164: WHERE ASL1.ITEM_ID = POL.item_id
3165: AND ASL1.using_organization_id in (PLL.ship_to_organization_id, -1))
3166: AND ASL.category_id in
3167: (SELECT MIC.category_id
3168: FROM MTL_ITEM_CATEGORIES MIC
3169: WHERE MIC.inventory_item_id = POL.item_id
3170: AND MIC.organization_id = PLL.ship_to_organization_id)
3171: AND ASL.asl_status_id = ASR.status_id
3172: AND ASR.business_rule = '1_PO_APPROVAL'

Line 3237: FROM MTL_ITEM_CATEGORIES MIC

3233: AND nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
3234: AND ASL.item_id is NULL
3235: AND ASL.category_id in
3236: (SELECT MIC.category_id
3237: FROM MTL_ITEM_CATEGORIES MIC
3238: WHERE MIC.inventory_item_id = POL.item_id
3239: AND MIC.organization_id = PLL.ship_to_organization_id)
3240: AND ASL.asl_status_id = ASR.status_id
3241: AND ASR.business_rule = '1_PO_APPROVAL'