DBA Data[Home] [Help]

APPS.AHL_VWP_MR_CST_PR_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 115: FROM MTL_SYSTEM_ITEMS_KFV

111: TITLE,
112: DESCRIPTION,
113: BILLING_ITEM_ID,
114: ( SELECT DISTINCT CONCATENATED_SEGMENTS
115: FROM MTL_SYSTEM_ITEMS_KFV
116: WHERE INVENTORY_ITEM_ID=BILLING_ITEM_ID) BILLING_ITEM
117: from AHL_MR_HEADERS_APP_V
118: where mr_header_id=c_mr_header_id ;
119: l_mr_rec c_mr_csr%rowtype;

Line 1355: from mtl_system_items_kfv mtl,

1351: select mtl.concatenated_segments,
1352: mtl.description,
1353: mtl.organization_id inventory_org_id,
1354: hou.name organization_name
1355: from mtl_system_items_kfv mtl,
1356: hr_organization_units hou,
1357: inv_organization_info_v org
1358: where mtl.organization_id = org.organization_id
1359: and hou.organization_id = org.organization_id