APPS.AHL_OSP_SHIPMENT_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 341: FROM mtl_system_items_b mtl,

337:
338: --mpothuku modified on 14-Sep-2007 to fix the Bug 6398921
339: CURSOR is_oe_item_IB_tracked(c_oe_line_id IN NUMBER, c_oe_org_id IN NUMBER) IS
340: SELECT 1
341: FROM mtl_system_items_b mtl,
342: oe_order_lines_all oel
343: WHERE oel.line_id = c_oe_line_id
344: AND mtl.inventory_item_id = oel.inventory_item_id
345: AND mtl.organization_id = c_oe_org_id

Line 2493: FROM MTL_SYSTEM_ITEMS_B

2489: CURSOR validate_item(p_inventory_item_id IN NUMBER,
2490: p_inventory_org_id IN NUMBER
2491: ) IS
2492: SELECT 1
2493: FROM MTL_SYSTEM_ITEMS_B
2494: WHERE ORGANIZATION_ID = p_inventory_org_id
2495: AND INVENTORY_ITEM_ID = p_inventory_item_id;
2496:
2497: -- Cursor to get the exchange instance and all its details from a OSP Line Id.

Line 6409: FROM mtl_system_items_b

6405:
6406: CURSOR get_inventory_flags(c_inv_item_id IN NUMBER, c_inv_org_id IN NUMBER) IS
6407: SELECT serial_number_control_code,
6408: comms_nl_trackable_flag
6409: FROM mtl_system_items_b
6410: WHERE inventory_item_id = c_inv_item_id
6411: AND organization_id = c_inv_org_id;
6412:
6413: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS

Line 6450: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;

6446: AND ospl.oe_return_line_id = oert.line_id(+);
6447:
6448: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Is_part_chg_valid_for_ospline';
6449: l_get_order_details get_order_details%ROWTYPE;
6450: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;
6451: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
6452: l_serial_status NUMBER;
6453: l_instance_id NUMBER;
6454: l_dummy NUMBER;

Line 6451: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;

6447:
6448: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Is_part_chg_valid_for_ospline';
6449: l_get_order_details get_order_details%ROWTYPE;
6450: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;
6451: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
6452: l_serial_status NUMBER;
6453: l_instance_id NUMBER;
6454: l_dummy NUMBER;
6455: l_ship_line_instance get_ship_line_instance%ROWTYPE;

Line 6682: FROM mtl_system_items_b

6678:
6679: CURSOR get_item_information(c_inv_item_id IN NUMBER, c_inv_org_id IN NUMBER) IS
6680: SELECT serial_number_control_code,
6681: comms_nl_trackable_flag
6682: FROM mtl_system_items_b
6683: WHERE inventory_item_id = c_inv_item_id
6684: AND organization_id = c_inv_org_id;
6685:
6686: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS