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 2458: FROM MTL_SYSTEM_ITEMS_B

2454: CURSOR validate_item(p_inventory_item_id IN NUMBER,
2455: p_inventory_org_id IN NUMBER
2456: ) IS
2457: SELECT 1
2458: FROM MTL_SYSTEM_ITEMS_B
2459: WHERE ORGANIZATION_ID = p_inventory_org_id
2460: AND INVENTORY_ITEM_ID = p_inventory_item_id;
2461:
2462: -- Cursor to get the exchange instance and all its details from a OSP Line Id.

Line 6364: FROM mtl_system_items_b

6360:
6361: CURSOR get_inventory_flags(c_inv_item_id IN NUMBER, c_inv_org_id IN NUMBER) IS
6362: SELECT serial_number_control_code,
6363: comms_nl_trackable_flag
6364: FROM mtl_system_items_b
6365: WHERE inventory_item_id = c_inv_item_id
6366: AND organization_id = c_inv_org_id;
6367:
6368: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS

Line 6405: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;

6401: AND ospl.oe_return_line_id = oert.line_id(+);
6402:
6403: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Is_part_chg_valid_for_ospline';
6404: l_get_order_details get_order_details%ROWTYPE;
6405: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;
6406: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
6407: l_serial_status NUMBER;
6408: l_instance_id NUMBER;
6409: l_dummy NUMBER;

Line 6406: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;

6402:
6403: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Is_part_chg_valid_for_ospline';
6404: l_get_order_details get_order_details%ROWTYPE;
6405: l_serial_number_control_code mtl_system_items_b.serial_number_control_code%TYPE;
6406: l_comms_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
6407: l_serial_status NUMBER;
6408: l_instance_id NUMBER;
6409: l_dummy NUMBER;
6410: l_ship_line_instance get_ship_line_instance%ROWTYPE;

Line 6637: FROM mtl_system_items_b

6633:
6634: CURSOR get_item_information(c_inv_item_id IN NUMBER, c_inv_org_id IN NUMBER) IS
6635: SELECT serial_number_control_code,
6636: comms_nl_trackable_flag
6637: FROM mtl_system_items_b
6638: WHERE inventory_item_id = c_inv_item_id
6639: AND organization_id = c_inv_org_id;
6640:
6641: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS