APPS.GMD_COA_DATA_OM_NEW dependencies on MTL_SYSTEM_ITEMS

Line 646: FROM mtl_system_items_b_kfv

642: --INVCONV
643: CURSOR c_get_item_no (p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER) IS
644: SELECT concatenated_segments item_number,
645: description item_description
646: FROM mtl_system_items_b_kfv
647: WHERE inventory_item_id = p_inventory_item_id
648: AND organization_id = p_organization_id;
649:
650:

Line 1346: FROM mtl_system_items

1342: PrintLn('l_coa_type = '||l_coa_type);
1343:
1344: -- Bug# 5010385
1345: SELECT lot_control_code INTO l_lot_ctl
1346: FROM mtl_system_items
1347: WHERE organization_id = p_hdr_rec.organization_id
1348: AND inventory_item_id = p_hdr_rec.inventory_item_id;
1349:
1350: PrintLn('Item lot_ctl = '||l_lot_ctl);

Line 1485: mtl_system_items_b_kfv msi, --INVCONV

1481: wsh_delivery_details wdd,
1482: wsh_new_deliveries wnd,
1483: wsh_delivery_assignments wda,
1484: mtl_parameters ship_from_org,
1485: mtl_system_items_b_kfv msi, --INVCONV
1486: hz_cust_accounts c,
1487: hz_cust_site_uses_all s,
1488: hz_cust_acct_sites_all a,
1489: hz_parties pr

Line 1546: mtl_system_items_b_kfv msi, --INVCONV

1542: FROM
1543: oe_order_headers_all h,
1544: oe_order_lines_all l,
1545: mtl_parameters ship_from_org,
1546: mtl_system_items_b_kfv msi, --INVCONV
1547: hz_cust_accounts c,
1548: hz_cust_site_uses_all s,
1549: hz_cust_acct_sites_all a,
1550: hz_parties pr