eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS

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 1191: FROM mtl_system_items msi,

1187:
1188: BEGIN
1189: SELECT primary_uom_code
1190: INTO l_primary_uom_code
1191: FROM mtl_system_items msi,
1192: mtl_parameters mp
1193: WHERE inventory_item_id = l_covered_inv_tbl(i).inventory_item_id
1194: AND mp.organization_id = msi.organization_id
1195: AND mp.organization_id = mp.master_organization_id

Line 1499: FROM mtl_system_items msi,

1495:
1496: BEGIN
1497: SELECT primary_uom_code
1498: INTO l_primary_uom_code
1499: FROM mtl_system_items msi,
1500: mtl_parameters mp
1501: WHERE inventory_item_id = l_inventorydetails_tbl(i).inventory_item_id
1502: AND mp.organization_id = msi.organization_id
1503: AND mp.organization_id = mp.master_organization_id

Line 1957: mtl_system_items msi,

1953: CURSOR get_list_price_csr (p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1954: SELECT
1955: msi.LIST_PRICE_PER_UNIT list_price
1956: FROM
1957: mtl_system_items msi,
1958: financials_system_params_all fspa
1959: WHERE
1960: msi.organization_id = fspa.inventory_organization_id and
1961: fspa.org_id = p_organization_id and

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;