DBA Data[Home] [Help]

APPS.CSP_RECEIVE_PVT dependencies on MTL_SUPPLY

Line 2401: from mtl_supply ms,

2397: l_locator_controlled Varchar2(1);
2398:
2399: CURSOR check_serial_lot_revision (v_header_id Number) is
2400: select ms.po_header_id
2401: from mtl_supply ms,
2402: po_lines_all pla,
2403: mtl_system_items_b msi
2404: where msi.organization_id = ms.to_organization_id
2405: and msi.inventory_item_id = ms.item_id

Line 2417: from mtl_supply ms

2413: CURSOR find_all_items(v_header_id number) is
2414: select ms.item_id,
2415: ms.to_organization_id,
2416: ms.to_subinventory
2417: from mtl_supply ms
2418: where ms.po_header_id = v_header_id;
2419:
2420: CURSOR locator_check (v_org_id Number, v_item_id number, v_sub_inv varchar2) IS
2421: select 'Y'