[Home] [Help]
649: SELECT msi.inventory_item_id,
650: msi.concatenated_segments,
651: msi.description,
652: occ.external_code
653: FROM mtl_system_items_kfv msi,
654: financials_system_params_all fspa,
655: ozf_supp_code_conversions_all occ
656: WHERE occ.internal_code = to_char(msi.inventory_item_id)
657: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
675: SELECT msi.inventory_item_id,
676: msi.concatenated_segments,
677: msi.description,
678: null external_code
679: FROM mtl_system_items_kfv msi,
680: financials_system_params_all fspa
681: WHERE msi.purchasing_item_flag = 'Y'
682: AND msi.shippable_item_flag = 'Y'
683: AND msi.enabled_flag = 'Y'
705: SELECT DISTINCT msi.inventory_item_id,
706: msi.concatenated_segments,
707: msi.description,
708: NULL external_code
709: FROM mtl_system_items_kfv msi,
710: financials_system_params_all fspa
711: WHERE msi.organization_id = fspa.inventory_organization_id
712: AND msi.purchasing_item_flag = 'Y'
713: AND msi.shippable_item_flag = 'Y'
862: msi.inventory_item_id,
863: msi.concatenated_segments,
864: msi.description
865: FROM
866: mtl_system_items_kfv msi,
867: mtl_parameters mp,
868: financials_system_params_all fspa,
869: oe_order_lines_all oola,
870: dpp_transaction_lines_all dtla
1148:
1149: BEGIN
1150: SELECT primary_uom_code
1151: INTO l_primary_uom_code
1152: FROM mtl_system_items msi,
1153: mtl_parameters mp
1154: WHERE inventory_item_id = l_covered_inv_tbl(i).inventory_item_id
1155: AND mp.organization_id = msi.organization_id
1156: AND mp.organization_id = mp.master_organization_id
1459:
1460: BEGIN
1461: SELECT primary_uom_code
1462: INTO l_primary_uom_code
1463: FROM mtl_system_items msi,
1464: mtl_parameters mp
1465: WHERE inventory_item_id = l_inventorydetails_tbl(i).inventory_item_id
1466: AND mp.organization_id = msi.organization_id
1467: AND mp.organization_id = mp.master_organization_id
1859: CURSOR get_list_price_csr (p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1860: SELECT
1861: msi.LIST_PRICE_PER_UNIT list_price
1862: FROM
1863: mtl_system_items msi,
1864: financials_system_params_all fspa
1865: WHERE
1866: msi.organization_id = fspa.inventory_organization_id and
1867: fspa.org_id = p_organization_id and
2283: CURSOR Get_Product_csr (p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)
2284: IS
2285: SELECT concatenated_segments,
2286: description
2287: FROM mtl_system_items_kfv msi,
2288: financials_system_params_all fspa
2289: WHERE fspa.org_id = p_org_id and
2290: fspa.inventory_organization_id = msi.organization_id and
2291: msi.inventory_item_id = p_inventory_item_id;