685: --INVCONV
686: CURSOR c_get_item_no (p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER) IS
687: SELECT concatenated_segments item_number,
688: description item_description
689: FROM mtl_system_items_b_kfv
690: WHERE inventory_item_id = p_inventory_item_id
691: AND organization_id = p_organization_id;
692:
693:
1430: PrintLn('l_coa_type = '||l_coa_type);
1431:
1432: -- Bug# 5010385
1433: SELECT lot_control_code INTO l_lot_ctl
1434: FROM mtl_system_items
1435: WHERE organization_id = p_hdr_rec.organization_id
1436: AND inventory_item_id = p_hdr_rec.inventory_item_id;
1437:
1438: PrintLn('Item lot_ctl = '||l_lot_ctl);
1573: wsh_delivery_details wdd,
1574: wsh_new_deliveries wnd,
1575: wsh_delivery_assignments wda,
1576: mtl_parameters ship_from_org,
1577: mtl_system_items_b_kfv msi, --INVCONV
1578: hz_cust_accounts c,
1579: hz_cust_site_uses_all s,
1580: hz_cust_acct_sites_all a,
1581: hz_parties pr
1656: wsh_delivery_details wdd,
1657: wsh_new_deliveries wnd,
1658: wsh_delivery_assignments wda,
1659: mtl_parameters ship_from_org,
1660: mtl_system_items_b_kfv msi, --INVCONV
1661: hz_cust_accounts c,
1662: hz_cust_site_uses_all s,
1663: hz_cust_acct_sites_all a,
1664: hz_parties pr
1718: FROM
1719: oe_order_headers_all h,
1720: oe_order_lines_all l,
1721: mtl_parameters ship_from_org,
1722: mtl_system_items_b_kfv msi, --INVCONV
1723: hz_cust_accounts c,
1724: hz_cust_site_uses_all s,
1725: hz_cust_acct_sites_all a,
1726: hz_parties pr