APPS.DPP_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 621: FROM mtl_system_items_kfv msi,

617: SELECT msi.inventory_item_id,
618: msi.concatenated_segments,
619: msi.description,
620: occ.external_code
621: FROM mtl_system_items_kfv msi,
622: financials_system_params_all fspa,
623: ozf_supp_code_conversions_all occ
624: WHERE occ.internal_code = to_char(msi.inventory_item_id)
625: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'

Line 647: FROM mtl_system_items_kfv msi,

643: SELECT msi.inventory_item_id,
644: msi.concatenated_segments,
645: msi.description,
646: null external_code
647: FROM mtl_system_items_kfv msi,
648: financials_system_params_all fspa
649: WHERE msi.purchasing_item_flag = 'Y'
650: AND msi.shippable_item_flag = 'Y'
651: AND msi.enabled_flag = 'Y'

Line 677: FROM mtl_system_items_kfv msi,

673: SELECT DISTINCT msi.inventory_item_id,
674: msi.concatenated_segments,
675: msi.description,
676: NULL external_code
677: FROM mtl_system_items_kfv msi,
678: financials_system_params_all fspa
679: WHERE msi.organization_id = fspa.inventory_organization_id
680: AND msi.purchasing_item_flag = 'Y'
681: AND msi.shippable_item_flag = 'Y'

Line 828: mtl_system_items_kfv msi,

824: msi.inventory_item_id,
825: msi.concatenated_segments,
826: msi.description
827: FROM
828: mtl_system_items_kfv msi,
829: mtl_parameters mp,
830: financials_system_params_all fspa,
831: oe_order_lines_all oola,
832: dpp_transaction_lines_all dtla

Line 920: mtl_system_items_kfv msi,

916: msi.inventory_item_id,
917: msi.concatenated_segments,
918: msi.description
919: FROM
920: mtl_system_items_kfv msi,
921: mtl_parameters mp,
922: financials_system_params_all fspa,
923: dpp_transaction_lines_all dtla
924: WHERE

Line 2369: FROM mtl_system_items_kfv msi,

2365: CURSOR Get_Product_csr (p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)
2366: IS
2367: SELECT concatenated_segments,
2368: description
2369: FROM mtl_system_items_kfv msi,
2370: financials_system_params_all fspa
2371: WHERE fspa.org_id = p_org_id and
2372: fspa.inventory_organization_id = msi.organization_id and
2373: msi.inventory_item_id = p_inventory_item_id;