DBA Data[Home] [Help]

APPS.AHL_VWP_MR_CST_PR_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 544: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls

540: -- AnRaj: Changed query for fixing the prformance bug# 4919272
541: Cursor c_mr_csr(c_mr_id in number, c_org_id in number)
542: Is
543: SELECT mr.billing_item_id, mr.mr_header_id,mtls.primary_uom_code UOM_CODE
544: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
545: WHERE mr.mr_header_id = c_mr_id
546: AND mr.billing_item_id = mtls.inventory_item_id
547: AND mtls.organization_id = c_org_id
548: AND billing_item_id IS NOT NULL;

Line 1264: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls

1260: Is
1261: SELECT mr.billing_item_id,
1262: mr.mr_header_id,
1263: mtls.primary_uom_code UOM_CODE
1264: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
1265: WHERE mr.MR_HEADER_ID = C_MR_ID
1266: AND mr.BILLING_ITEM_ID = mtls.INVENTORY_ITEM_ID
1267: AND mtls.organization_id = c_org_id
1268: AND billing_item_id IS NOT NULL ;