APPS.CSP_RECEIVE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1621: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1619: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1620: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
1621: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1622:
1623: l_api_version CONSTANT NUMBER := 1.0;
1624: l_api_name CONSTANT VARCHAR2(30) := 'insert_lots_interface';
1625: l_transaction_interface_id Number;

Line 2291: mtl_system_items_b msi

2287: CURSOR check_serial_lot_revision (v_header_id Number) is
2288: select ms.po_header_id
2289: from mtl_supply ms,
2290: po_lines_all pla,
2291: mtl_system_items_b msi
2292: where msi.organization_id = ms.to_organization_id
2293: and msi.inventory_item_id = ms.item_id
2294: and pla.po_line_id = ms.po_line_id
2295: and ms.po_header_id = v_header_id

Line 2311: mtl_system_items_b b,

2307:
2308: CURSOR locator_check (v_org_id Number, v_item_id number, v_sub_inv varchar2) IS
2309: select 'Y'
2310: from mtl_parameters a,
2311: mtl_system_items_b b,
2312: mtl_secondary_inventories c
2313: where a.organization_id = b.organization_id
2314: and a.organization_id = c.organization_id
2315: and a.organization_id = v_org_id