DBA Data[Home] [Help]

APPS.PO_COPYDOC_S4 dependencies on MTL_SYSTEM_ITEMS

Line 139: FROM mtl_system_items msi

135: SELECT msi.invoice_close_tolerance,
136: msi.receive_close_tolerance
137: INTO l_invoice_close_tolerance,
138: l_receive_close_tolerance
139: FROM mtl_system_items msi
140: WHERE msi.inventory_item_id = l_item_id
141: AND msi.organization_id = x_po_shipment_record.ship_to_organization_id;
142: exception
143: when others then null;

Line 150: FROM mtl_system_items msi

146: SELECT nvl(l_invoice_close_tolerance,msi.invoice_close_tolerance),
147: nvl(l_receive_close_tolerance,msi.receive_close_tolerance)
148: INTO l_invoice_close_tolerance,
149: l_receive_close_tolerance
150: FROM mtl_system_items msi
151: WHERE msi.inventory_item_id = l_item_id
152: AND msi.organization_id = p_inv_org_id;
153: exception
154: when others then null;