APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_LOT_SERIAL_NUMBERS

Line 3913: FROM oe_lot_serial_numbers

3909: AND org.name = p_name;
3910:
3911: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
3912: SELECT lot_serial_id
3913: FROM oe_lot_serial_numbers
3914: WHERE line_id = p_oe_line_id;
3915:
3916: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Convert_Line_Tbl';
3917: --

Line 6688: FROM oe_lot_serial_numbers

6684: AND organization_id = c_inv_org_id;
6685:
6686: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
6687: SELECT lot_serial_id
6688: FROM oe_lot_serial_numbers
6689: WHERE line_id = p_oe_line_id;
6690:
6691: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
6692: SELECT matched_ol.osp_order_line_id