APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_LOT_SERIAL_NUMBERS

Line 3929: FROM oe_lot_serial_numbers

3925: AND org.name = p_name;
3926:
3927: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
3928: SELECT lot_serial_id
3929: FROM oe_lot_serial_numbers
3930: WHERE line_id = p_oe_line_id;
3931:
3932: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Convert_Line_Tbl';
3933: --

Line 6643: FROM oe_lot_serial_numbers

6639: AND organization_id = c_inv_org_id;
6640:
6641: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
6642: SELECT lot_serial_id
6643: FROM oe_lot_serial_numbers
6644: WHERE line_id = p_oe_line_id;
6645:
6646: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
6647: SELECT matched_ol.osp_order_line_id