APPS.AHL_OSP_UTIL_PKG dependencies on OE_LOT_SERIAL_NUMBERS

Line 734: SELECT FROM_SERIAL_NUMBER from oe_lot_serial_numbers

730: SELECT serial_number FROM csi_item_instances
731: WHERE instance_id = c_instance_id;
732:
733: cursor get_serial_from_oelsn_csr IS
734: SELECT FROM_SERIAL_NUMBER from oe_lot_serial_numbers
735: where LINE_ID = p_ship_line_id;
736:
737: osp_line_details_rec get_line_details_csr%ROWTYPE;
738:

Line 774: -- Not OSP Line Based: Get the serial number from oe_lot_serial_numbers

770: END IF;
771: end if;
772: end if;
773: else
774: -- Not OSP Line Based: Get the serial number from oe_lot_serial_numbers
775: -- Note that this oe_lot_serial_numbers applies only for return lines
776: open get_serial_from_oelsn_csr;
777: fetch get_serial_from_oelsn_csr into l_serial_number;
778: close get_serial_from_oelsn_csr;

Line 775: -- Note that this oe_lot_serial_numbers applies only for return lines

771: end if;
772: end if;
773: else
774: -- Not OSP Line Based: Get the serial number from oe_lot_serial_numbers
775: -- Note that this oe_lot_serial_numbers applies only for return lines
776: open get_serial_from_oelsn_csr;
777: fetch get_serial_from_oelsn_csr into l_serial_number;
778: close get_serial_from_oelsn_csr;
779: end if;

Line 810: SELECT LOT_NUMBER from oe_lot_serial_numbers

806: SELECT lot_number FROM csi_item_instances
807: WHERE instance_id = c_instance_id;
808:
809: cursor get_lot_num_from_oelsn_csr IS
810: SELECT LOT_NUMBER from oe_lot_serial_numbers
811: where LINE_ID = p_ship_line_id;
812:
813: osp_line_details_rec get_line_details_csr%ROWTYPE;
814:

Line 850: -- Not OSP Line Based: Get the lot number from oe_lot_serial_numbers

846: END IF;
847: end if;
848: end if;
849: else
850: -- Not OSP Line Based: Get the lot number from oe_lot_serial_numbers
851: -- Note that this oe_lot_serial_numbers applies only for return lines
852: open get_lot_num_from_oelsn_csr;
853: fetch get_lot_num_from_oelsn_csr into l_lot_number;
854: close get_lot_num_from_oelsn_csr;

Line 851: -- Note that this oe_lot_serial_numbers applies only for return lines

847: end if;
848: end if;
849: else
850: -- Not OSP Line Based: Get the lot number from oe_lot_serial_numbers
851: -- Note that this oe_lot_serial_numbers applies only for return lines
852: open get_lot_num_from_oelsn_csr;
853: fetch get_lot_num_from_oelsn_csr into l_lot_number;
854: close get_lot_num_from_oelsn_csr;
855: end if;