eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_SERIAL_NUMBERS

Line 2024: l_cur_serial_number mtl_serial_numbers.serial_number%type;

2020: l_range_numbers NUMBER;
2021: l_ser_num_length NUMBER;
2022: l_prefix_length NUMBER;
2023: l_cur_ser_num NUMBER;
2024: l_cur_serial_number mtl_serial_numbers.serial_number%type;
2025:
2026: --Bug #2966531 - Cursor to store serial attributes from MSN
2027: CURSOR c_msn_attributes( v_serial_number VARCHAR2
2028: , v_inventory_item_id NUMBER) IS

Line 2042: FROM mtl_serial_numbers

2038: , d_attribute4, d_attribute5, d_attribute6, d_attribute7, d_attribute8
2039: , d_attribute9, d_attribute10, n_attribute1, n_attribute2, n_attribute3
2040: , n_attribute4, n_attribute5, n_attribute6, n_attribute7, n_attribute8
2041: , n_attribute9, n_attribute10
2042: FROM mtl_serial_numbers
2043: WHERE serial_number = v_serial_number
2044: AND inventory_item_id = v_inventory_item_id;
2045:
2046: TYPE msn_attribute_rec_tp IS RECORD (

Line 2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,

2043: WHERE serial_number = v_serial_number
2044: AND inventory_item_id = v_inventory_item_id;
2045:
2046: TYPE msn_attribute_rec_tp IS RECORD (
2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,
2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,

Line 2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,

2044: AND inventory_item_id = v_inventory_item_id;
2045:
2046: TYPE msn_attribute_rec_tp IS RECORD (
2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,
2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,

Line 2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,

2045:
2046: TYPE msn_attribute_rec_tp IS RECORD (
2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,
2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,

Line 2050: origination_date mtl_serial_numbers.origination_date%type,

2046: TYPE msn_attribute_rec_tp IS RECORD (
2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,
2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,

Line 2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,

2047: vendor_serial_number mtl_serial_numbers.vendor_serial_number%type,
2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,

Line 2052: territory_code mtl_serial_numbers.territory_code%type,

2048: vendor_lot_number mtl_serial_numbers.vendor_lot_number%type,
2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,

Line 2053: time_since_new mtl_serial_numbers.time_since_new%type,

2049: parent_serial_number mtl_serial_numbers.parent_serial_number%type,
2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,

Line 2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,

2050: origination_date mtl_serial_numbers.origination_date%type,
2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,

Line 2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,

2051: end_item_unit_number mtl_serial_numbers.end_item_unit_number%type,
2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,

Line 2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,

2052: territory_code mtl_serial_numbers.territory_code%type,
2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,

Line 2057: time_since_repair mtl_serial_numbers.time_since_repair%type,

2053: time_since_new mtl_serial_numbers.time_since_new%type,
2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,

Line 2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,

2054: cycles_since_new mtl_serial_numbers.cycles_since_new%type,
2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,

Line 2059: time_since_visit mtl_serial_numbers.time_since_visit%type,

2055: time_since_overhaul mtl_serial_numbers.time_since_overhaul%type,
2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,

Line 2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,

2056: cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%type,
2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,

Line 2061: time_since_mark mtl_serial_numbers.time_since_mark%type,

2057: time_since_repair mtl_serial_numbers.time_since_repair%type,
2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,

Line 2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,

2058: cycles_since_repair mtl_serial_numbers.cycles_since_repair%type,
2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,

Line 2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,

2059: time_since_visit mtl_serial_numbers.time_since_visit%type,
2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,

Line 2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,

2060: cycles_since_visit mtl_serial_numbers.cycles_since_visit%type,
2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,

Line 2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,

2061: time_since_mark mtl_serial_numbers.time_since_mark%type,
2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,

Line 2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,

2062: cycles_since_mark mtl_serial_numbers.cycles_since_mark%type,
2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,

Line 2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,

2063: number_of_repairs mtl_serial_numbers.number_of_repairs%type,
2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,

Line 2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,

2064: serial_attribute_category mtl_serial_numbers.serial_attribute_category%type,
2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,

Line 2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,

2065: c_attribute1 mtl_serial_numbers.c_attribute1%type,
2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,

Line 2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,

2066: c_attribute2 mtl_serial_numbers.c_attribute2%type,
2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,

Line 2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,

2067: c_attribute3 mtl_serial_numbers.c_attribute3%type,
2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,

Line 2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,

2068: c_attribute4 mtl_serial_numbers.c_attribute4%type,
2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,

Line 2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,

2069: c_attribute5 mtl_serial_numbers.c_attribute5%type,
2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,

Line 2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,

2070: c_attribute6 mtl_serial_numbers.c_attribute6%type,
2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,

Line 2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,

2071: c_attribute7 mtl_serial_numbers.c_attribute7%type,
2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,

Line 2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,

2072: c_attribute8 mtl_serial_numbers.c_attribute8%type,
2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,

Line 2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,

2073: c_attribute9 mtl_serial_numbers.c_attribute9%type,
2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,

Line 2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,

2074: c_attribute10 mtl_serial_numbers.c_attribute10%type,
2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,

Line 2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,

2075: c_attribute11 mtl_serial_numbers.c_attribute11%type,
2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,

Line 2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,

2076: c_attribute12 mtl_serial_numbers.c_attribute12%type,
2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,

Line 2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,

2077: c_attribute13 mtl_serial_numbers.c_attribute13%type,
2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,

Line 2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,

2078: c_attribute14 mtl_serial_numbers.c_attribute14%type,
2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,

Line 2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,

2079: c_attribute15 mtl_serial_numbers.c_attribute15%type,
2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,

Line 2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,

2080: c_attribute16 mtl_serial_numbers.c_attribute16%type,
2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,

Line 2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,

2081: c_attribute17 mtl_serial_numbers.c_attribute17%type,
2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,

Line 2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,

2082: c_attribute18 mtl_serial_numbers.c_attribute18%type,
2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,

Line 2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,

2083: c_attribute19 mtl_serial_numbers.c_attribute19%type,
2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,

Line 2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,

2084: c_attribute20 mtl_serial_numbers.c_attribute20%type,
2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,

Line 2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,

2085: d_attribute1 mtl_serial_numbers.d_attribute1%type,
2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,

Line 2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,

2086: d_attribute2 mtl_serial_numbers.d_attribute2%type,
2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,

Line 2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,

2087: d_attribute3 mtl_serial_numbers.d_attribute3%type,
2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,

Line 2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,

2088: d_attribute4 mtl_serial_numbers.d_attribute4%type,
2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,

Line 2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,

2089: d_attribute5 mtl_serial_numbers.d_attribute5%type,
2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,

Line 2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,

2090: d_attribute6 mtl_serial_numbers.d_attribute6%type,
2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,

Line 2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,

2091: d_attribute7 mtl_serial_numbers.d_attribute7%type,
2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,

Line 2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,

2092: d_attribute8 mtl_serial_numbers.d_attribute8%type,
2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,

Line 2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,

2093: d_attribute9 mtl_serial_numbers.d_attribute9%type,
2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,

Line 2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,

2094: d_attribute10 mtl_serial_numbers.d_attribute10%type,
2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,

Line 2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,

2095: n_attribute1 mtl_serial_numbers.n_attribute1%type,
2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,

Line 2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,

2096: n_attribute2 mtl_serial_numbers.n_attribute2%type,
2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,
2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );

Line 2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,

2097: n_attribute3 mtl_serial_numbers.n_attribute3%type,
2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,
2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );
2105:

Line 2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,

2098: n_attribute4 mtl_serial_numbers.n_attribute4%type,
2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,
2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );
2105:
2106: l_msn_attribute_rec msn_attribute_rec_tp;

Line 2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,

2099: n_attribute5 mtl_serial_numbers.n_attribute5%type,
2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,
2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );
2105:
2106: l_msn_attribute_rec msn_attribute_rec_tp;
2107: BEGIN

Line 2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );

2100: n_attribute6 mtl_serial_numbers.n_attribute6%type,
2101: n_attribute7 mtl_serial_numbers.n_attribute7%type,
2102: n_attribute8 mtl_serial_numbers.n_attribute8%type,
2103: n_attribute9 mtl_serial_numbers.n_attribute9%type,
2104: n_attribute10 mtl_serial_numbers.n_attribute10%type );
2105:
2106: l_msn_attribute_rec msn_attribute_rec_tp;
2107: BEGIN
2108: l_org_id := p_org_id;

Line 2225: INSERT INTO mtl_serial_numbers_temp

2221: OPEN c_msn_attributes(l_cur_serial_number, l_item_id);
2222: FETCH c_msn_attributes INTO l_msn_attribute_rec;
2223: CLOSE c_msn_attributes;
2224:
2225: INSERT INTO mtl_serial_numbers_temp
2226: ( TRANSACTION_TEMP_ID
2227: , LAST_UPDATE_DATE
2228: , LAST_UPDATED_BY
2229: , CREATION_DATE

Line 2362: /*INSERT INTO mtl_serial_numbers_temp

2358: );
2359: END LOOP; --END for each serial number
2360: -- Insert into serial
2361: --mydebug('process_lot_serial: Inserting Serials');
2362: /*INSERT INTO mtl_serial_numbers_temp
2363: (
2364: transaction_temp_id
2365: , last_update_date
2366: , last_updated_by

Line 2416: INSERT INTO mtl_serial_numbers_temp

2412: OPEN c_msn_attributes(l_cur_serial_number, l_item_id);
2413: FETCH c_msn_attributes INTO l_msn_attribute_rec;
2414: CLOSE c_msn_attributes;
2415:
2416: INSERT INTO mtl_serial_numbers_temp
2417: ( TRANSACTION_TEMP_ID
2418: , LAST_UPDATE_DATE
2419: , LAST_UPDATED_BY
2420: , CREATION_DATE

Line 2552: /* INSERT INTO mtl_serial_numbers_temp

2548: , l_msn_attribute_rec.n_attribute10
2549: );
2550: END LOOP; --END for each each serial
2551:
2552: /* INSERT INTO mtl_serial_numbers_temp
2553: (
2554: transaction_temp_id
2555: , last_update_date
2556: , last_updated_by

Line 2725: FROM mtl_serial_numbers

2721: l_mil_task_id NUMBER ; -- 2774506/2905646
2722:
2723: CURSOR ser_csr IS
2724: SELECT serial_number
2725: FROM mtl_serial_numbers
2726: WHERE lpn_id = p_lpn
2727: AND inventory_item_id = p_item_id
2728: AND NVL(lot_number, -999) = NVL(p_lot, -999);
2729:

Line 3443: FROM mtl_serial_numbers_temp msnt

3439: END IF;
3440:
3441: SELECT COUNT(fm_serial_number)
3442: INTO l_serial_exist_cnt
3443: FROM mtl_serial_numbers_temp msnt
3444: WHERE msnt.transaction_temp_id = p_temp_id
3445: AND msnt.fm_serial_number IN(
3446: SELECT serial_number
3447: FROM mtl_serial_numbers

Line 3447: FROM mtl_serial_numbers

3443: FROM mtl_serial_numbers_temp msnt
3444: WHERE msnt.transaction_temp_id = p_temp_id
3445: AND msnt.fm_serial_number IN(
3446: SELECT serial_number
3447: FROM mtl_serial_numbers
3448: WHERE lpn_id = p_lpn
3449: AND inventory_item_id = p_item_id
3450: AND NVL(revision, '-999') = NVL(p_rev, '-999'));
3451:

Line 3470: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

3466: END IF;
3467:
3468: SELECT COUNT(fm_serial_number)
3469: INTO l_total_serial_cnt
3470: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
3471: WHERE mtlt.transaction_temp_id = p_temp_id
3472: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
3473:
3474: IF (l_debug = 1) THEN

Line 3776: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

3772: END IF;
3773:
3774: SELECT COUNT(fm_serial_number)
3775: INTO l_serial_exist_cnt
3776: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
3777: WHERE mtlt.transaction_temp_id = p_temp_id
3778: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3779: AND msnt.fm_serial_number IN(
3780: SELECT serial_number

Line 3781: FROM mtl_serial_numbers

3777: WHERE mtlt.transaction_temp_id = p_temp_id
3778: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3779: AND msnt.fm_serial_number IN(
3780: SELECT serial_number
3781: FROM mtl_serial_numbers
3782: WHERE lpn_id = p_lpn
3783: AND inventory_item_id = p_item_id
3784: AND NVL(revision, '-999') = NVL(p_rev, '-999'));
3785:

Line 4229: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

4225: AND(x_match = 1
4226: OR x_match = 3) THEN
4227: SELECT COUNT(fm_serial_number)
4228: INTO l_total_serial_cnt
4229: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
4230: WHERE mtlt.transaction_temp_id = p_temp_id
4231: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
4232:
4233: IF (l_debug = 1) THEN

Line 4273: FROM mtl_serial_numbers_temp msnt

4269: END IF;
4270:
4271: SELECT COUNT(fm_serial_number)
4272: INTO l_serial_exist_cnt
4273: FROM mtl_serial_numbers_temp msnt
4274: WHERE msnt.transaction_temp_id = p_temp_id
4275: AND msnt.fm_serial_number IN(
4276: SELECT serial_number
4277: FROM mtl_serial_numbers

Line 4277: FROM mtl_serial_numbers

4273: FROM mtl_serial_numbers_temp msnt
4274: WHERE msnt.transaction_temp_id = p_temp_id
4275: AND msnt.fm_serial_number IN(
4276: SELECT serial_number
4277: FROM mtl_serial_numbers
4278: WHERE lpn_id = p_lpn
4279: AND inventory_item_id = p_item_id
4280: AND NVL(revision, '-999') = NVL(p_rev, '-999'));
4281:

Line 4621: FROM mtl_serial_numbers_temp msnt

4617: AND(x_match = 1
4618: OR x_match = 3) THEN
4619: SELECT COUNT(fm_serial_number)
4620: INTO l_total_serial_cnt
4621: FROM mtl_serial_numbers_temp msnt
4622: WHERE msnt.transaction_temp_id = p_temp_id;
4623:
4624: IF (l_debug = 1) THEN
4625: mydebug('lpn_match: SN tot count' || l_total_serial_cnt);

Line 4762: FROM mtl_serial_numbers_temp msnt,

4758: mydebug('lpn_match: l_temp_serial_trans_temp is not null');
4759: END IF;
4760: SELECT 1
4761: INTO l_allocate_serial_flag
4762: FROM mtl_serial_numbers_temp msnt,
4763: mtl_serial_numbers msn
4764: WHERE msnt.transaction_temp_id = l_temp_serial_trans_temp
4765: AND msn.serial_number = msnt.fm_serial_number
4766: AND msn.lpn_id = p_lpn

Line 4763: mtl_serial_numbers msn

4759: END IF;
4760: SELECT 1
4761: INTO l_allocate_serial_flag
4762: FROM mtl_serial_numbers_temp msnt,
4763: mtl_serial_numbers msn
4764: WHERE msnt.transaction_temp_id = l_temp_serial_trans_temp
4765: AND msn.serial_number = msnt.fm_serial_number
4766: AND msn.lpn_id = p_lpn
4767: AND ROWNUM = 1;

Line 4777: mtl_serial_numbers_temp msnt,

4773: END IF;
4774: SELECT 1
4775: INTO l_allocate_serial_flag
4776: FROM mtl_material_transactions_temp mmtt,
4777: mtl_serial_numbers_temp msnt,
4778: mtl_serial_numbers msn
4779: WHERE mmtt.transaction_temp_id = p_temp_id
4780: AND mmtt.organization_id = p_org_id
4781: AND mmtt.inventory_item_id = p_item_id

Line 4778: mtl_serial_numbers msn

4774: SELECT 1
4775: INTO l_allocate_serial_flag
4776: FROM mtl_material_transactions_temp mmtt,
4777: mtl_serial_numbers_temp msnt,
4778: mtl_serial_numbers msn
4779: WHERE mmtt.transaction_temp_id = p_temp_id
4780: AND mmtt.organization_id = p_org_id
4781: AND mmtt.inventory_item_id = p_item_id
4782: AND msnt.transaction_temp_id = mmtt.transaction_temp_id

Line 5708: UPDATE mtl_serial_numbers

5704: mydebug('load_pick : ' || l_tabtype(l_counter));
5705: END IF;
5706:
5707: IF p_is_serial_control = 'true' THEN
5708: UPDATE mtl_serial_numbers
5709: SET group_mark_id = NULL
5710: WHERE inventory_item_id = l_item_id
5711: AND current_organization_id = p_org_id
5712: AND serial_number IN(SELECT fm_serial_number

Line 5713: FROM mtl_serial_numbers_temp

5709: SET group_mark_id = NULL
5710: WHERE inventory_item_id = l_item_id
5711: AND current_organization_id = p_org_id
5712: AND serial_number IN(SELECT fm_serial_number
5713: FROM mtl_serial_numbers_temp
5714: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5715: FROM mtl_transaction_lots_temp
5716: WHERE lot_number = l_tabtype(l_counter)
5717: AND transaction_temp_id = p_temp_id));

Line 5719: DELETE FROM mtl_serial_numbers_temp

5715: FROM mtl_transaction_lots_temp
5716: WHERE lot_number = l_tabtype(l_counter)
5717: AND transaction_temp_id = p_temp_id));
5718:
5719: DELETE FROM mtl_serial_numbers_temp
5720: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5721: FROM mtl_transaction_lots_temp
5722: WHERE lot_number = l_tabtype(l_counter)
5723: AND transaction_temp_id = p_temp_id);

Line 5736: UPDATE mtl_serial_numbers msn

5732: IF p_is_serial_control = 'true' THEN
5733: IF p_qty_rsn_id > 0 THEN
5734: -- Deleting serials which have not been picked
5735:
5736: UPDATE mtl_serial_numbers msn
5737: SET msn.group_mark_id = NULL
5738: WHERE msn.inventory_item_id = l_item_id
5739: AND msn.current_organization_id = p_org_id
5740: AND msn.group_mark_id = p_temp_id

Line 5742: FROM mtl_serial_numbers_temp msnt

5738: WHERE msn.inventory_item_id = l_item_id
5739: AND msn.current_organization_id = p_org_id
5740: AND msn.group_mark_id = p_temp_id
5741: AND msn.serial_number IN(SELECT msnt.fm_serial_number
5742: FROM mtl_serial_numbers_temp msnt
5743: WHERE msnt.transaction_temp_id = p_temp_id);
5744:
5745: DELETE FROM mtl_serial_numbers_temp msnt
5746: WHERE msnt.transaction_temp_id = p_temp_id

Line 5745: DELETE FROM mtl_serial_numbers_temp msnt

5741: AND msn.serial_number IN(SELECT msnt.fm_serial_number
5742: FROM mtl_serial_numbers_temp msnt
5743: WHERE msnt.transaction_temp_id = p_temp_id);
5744:
5745: DELETE FROM mtl_serial_numbers_temp msnt
5746: WHERE msnt.transaction_temp_id = p_temp_id
5747: AND msnt.fm_serial_number IN(
5748: SELECT msn.serial_number
5749: FROM mtl_serial_numbers msn

Line 5749: FROM mtl_serial_numbers msn

5745: DELETE FROM mtl_serial_numbers_temp msnt
5746: WHERE msnt.transaction_temp_id = p_temp_id
5747: AND msnt.fm_serial_number IN(
5748: SELECT msn.serial_number
5749: FROM mtl_serial_numbers msn
5750: WHERE msn.inventory_item_id = l_item_id
5751: AND msn.current_organization_id = p_org_id
5752: AND msn.group_mark_id IS NULL);
5753: END IF;

Line 5816: UPDATE mtl_serial_numbers_temp

5812: UPDATE mtl_transaction_lots_temp
5813: SET transaction_temp_id = p_temp_id
5814: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5815: ELSIF p_is_serial_control = 'true' THEN
5816: UPDATE mtl_serial_numbers_temp
5817: SET transaction_temp_id = p_temp_id
5818: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5819: END IF;
5820:

Line 6861: FROM mtl_serial_numbers

6857: l_txn_header_id NUMBER;
6858:
6859: CURSOR lpn_ser_cur(v_lot_number VARCHAR2) IS
6860: SELECT serial_number
6861: FROM mtl_serial_numbers
6862: WHERE lpn_id = p_lpn_id
6863: AND NVL(lot_number, 'NONE') = NVL(v_lot_number, 'NONE');
6864:
6865: CURSOR lpn_lot_cur IS

Line 7513: UPDATE mtl_serial_numbers_temp

7509: LOOP
7510: FETCH lpn_ser_cur INTO l_serial_number;
7511: EXIT WHEN lpn_ser_cur%NOTFOUND;
7512:
7513: UPDATE mtl_serial_numbers_temp
7514: SET transaction_temp_id = l_new_serial_temp_id
7515: WHERE transaction_temp_id = l_lot_serial_temp_id
7516: AND fm_serial_number = l_serial_number
7517: AND to_serial_number = l_serial_number;

Line 7652: INSERT INTO mtl_serial_numbers_temp

7648: LOOP
7649: FETCH lpn_ser_cur INTO l_serial_number;
7650: EXIT WHEN lpn_ser_cur%NOTFOUND;
7651:
7652: INSERT INTO mtl_serial_numbers_temp
7653: (
7654: transaction_temp_id
7655: , last_update_date
7656: , last_updated_by

Line 7709: INSERT INTO mtl_serial_numbers_temp

7705: LOOP
7706: FETCH lpn_ser_cur INTO l_serial_number;
7707: EXIT WHEN lpn_ser_cur%NOTFOUND;
7708:
7709: INSERT INTO mtl_serial_numbers_temp
7710: (
7711: transaction_temp_id
7712: , last_update_date
7713: , last_updated_by

Line 7753: UPDATE mtl_serial_numbers_temp

7749: LOOP
7750: FETCH lpn_ser_cur INTO l_serial_number;
7751: EXIT WHEN lpn_ser_cur%NOTFOUND;
7752:
7753: UPDATE mtl_serial_numbers_temp
7754: SET transaction_temp_id = l_new_temp_id
7755: WHERE transaction_temp_id = p_temp_id
7756: AND fm_serial_number = l_serial_number
7757: AND to_serial_number = l_serial_number;

Line 7773: INSERT INTO mtl_serial_numbers_temp

7769: LOOP
7770: FETCH lpn_ser_cur INTO l_serial_number;
7771: EXIT WHEN lpn_ser_cur%NOTFOUND;
7772:
7773: INSERT INTO mtl_serial_numbers_temp
7774: (
7775: transaction_temp_id
7776: , last_update_date
7777: , last_updated_by

Line 9860: UPDATE mtl_serial_numbers_temp

9856: FROM DUAL;
9857:
9858: l_progress := '310';
9859:
9860: UPDATE mtl_serial_numbers_temp
9861: SET transaction_temp_id = l_new_serial_temp_id
9862: WHERE transaction_temp_id = l_mtlt_rec.serial_transaction_temp_id
9863: AND fm_serial_number = l_fm_serial
9864: AND to_serial_number = l_to_serial;

Line 9933: UPDATE mtl_serial_numbers_temp

9929: END IF;
9930:
9931: l_progress := '380';
9932:
9933: UPDATE mtl_serial_numbers_temp
9934: SET transaction_temp_id = l_new_temp_id
9935: WHERE transaction_temp_id = l_temp_id
9936: AND fm_serial_number = l_fm_serial
9937: AND to_serial_number = l_to_serial;

Line 10123: INSERT INTO mtl_serial_numbers_temp

10119:
10120: l_progress := '460';
10121:
10122: IF p_sn_allocated_flag = 'N' THEN
10123: INSERT INTO mtl_serial_numbers_temp
10124: (
10125: transaction_temp_id
10126: , last_update_date
10127: , last_updated_by

Line 10150: UPDATE mtl_serial_numbers

10146: IF (l_debug = 1) THEN
10147: mydebug('multiple_pick: updating msn for l_new_serial_temp_id = ' || l_new_serial_temp_id);
10148: END IF;
10149:
10150: UPDATE mtl_serial_numbers
10151: SET group_mark_id = l_txn_header_id
10152: WHERE inventory_item_id = l_item_id
10153: AND current_organization_id = p_org_id
10154: AND serial_number IN(SELECT fm_serial_number

Line 10155: FROM mtl_serial_numbers_temp msnt

10151: SET group_mark_id = l_txn_header_id
10152: WHERE inventory_item_id = l_item_id
10153: AND current_organization_id = p_org_id
10154: AND serial_number IN(SELECT fm_serial_number
10155: FROM mtl_serial_numbers_temp msnt
10156: WHERE msnt.transaction_temp_id = l_new_serial_temp_id);
10157:
10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: SELECT count(MSNT.transaction_temp_id)

Line 10161: FROM Mtl_Serial_Numbers_Temp MSNT

10157:
10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: SELECT count(MSNT.transaction_temp_id)
10160: INTO l_serial_count
10161: FROM Mtl_Serial_Numbers_Temp MSNT
10162: WHERE MSNT.fm_serial_number = l_fm_serial;
10163:
10164: /*Bug#3957819.IF the serial number is already used , throw an error*/
10165: IF l_serial_count > 1 THEN

Line 10206: INSERT INTO mtl_serial_numbers_temp

10202: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10203: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10204: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10205:
10206: INSERT INTO mtl_serial_numbers_temp
10207: (
10208: transaction_temp_id
10209: , last_update_date
10210: , last_updated_by

Line 10231: UPDATE mtl_serial_numbers

10227: END IF;
10228:
10229: l_progress := '520';
10230:
10231: UPDATE mtl_serial_numbers
10232: SET group_mark_id = l_txn_header_id
10233: WHERE inventory_item_id = l_item_id
10234: AND current_organization_id = p_org_id
10235: AND serial_number IN(SELECT fm_serial_number

Line 10236: FROM mtl_serial_numbers_temp msnt

10232: SET group_mark_id = l_txn_header_id
10233: WHERE inventory_item_id = l_item_id
10234: AND current_organization_id = p_org_id
10235: AND serial_number IN(SELECT fm_serial_number
10236: FROM mtl_serial_numbers_temp msnt
10237: WHERE msnt.transaction_temp_id = l_local_temp_id);
10238:
10239: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10240: SELECT count(MSNT.transaction_temp_id)

Line 10242: FROM Mtl_Serial_Numbers_Temp MSNT

10238:
10239: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10240: SELECT count(MSNT.transaction_temp_id)
10241: INTO l_serial_count
10242: FROM Mtl_Serial_Numbers_Temp MSNT
10243: WHERE MSNT.fm_serial_number = l_fm_serial;
10244:
10245:
10246: /*Bug#3957819.IF the serial number is already used , throw an error*/

Line 10308: INSERT INTO mtl_serial_numbers_temp

10304: l_new_serial_temp_id := l_lot_ser_seq;
10305: END IF;
10306:
10307: IF p_sn_allocated_flag = 'N' THEN
10308: INSERT INTO mtl_serial_numbers_temp
10309: (
10310: transaction_temp_id
10311: , last_update_date
10312: , last_updated_by

Line 10331: UPDATE mtl_serial_numbers

10327: END IF;
10328:
10329: l_progress := '570';
10330:
10331: UPDATE mtl_serial_numbers
10332: SET group_mark_id = l_txn_header_id
10333: WHERE inventory_item_id = l_item_id
10334: AND current_organization_id = p_org_id
10335: AND serial_number IN(SELECT fm_serial_number

Line 10336: FROM mtl_serial_numbers_temp

10332: SET group_mark_id = l_txn_header_id
10333: WHERE inventory_item_id = l_item_id
10334: AND current_organization_id = p_org_id
10335: AND serial_number IN(SELECT fm_serial_number
10336: FROM mtl_serial_numbers_temp
10337: WHERE transaction_temp_id = l_new_serial_temp_id);
10338:
10339: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10340: SELECT count(MSNT.transaction_temp_id)

Line 10342: FROM Mtl_Serial_Numbers_Temp MSNT

10338:
10339: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10340: SELECT count(MSNT.transaction_temp_id)
10341: INTO l_serial_count
10342: FROM Mtl_Serial_Numbers_Temp MSNT
10343: WHERE MSNT.fm_serial_number = l_fm_serial;
10344:
10345: /*Bug#3957819.IF the serial number is already used , throw an error*/
10346: IF l_serial_count > 1 THEN

Line 10379: INSERT INTO mtl_serial_numbers_temp

10375: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10376: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10377: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10378:
10379: INSERT INTO mtl_serial_numbers_temp
10380: (
10381: transaction_temp_id
10382: , last_update_date
10383: , last_updated_by

Line 10404: UPDATE mtl_serial_numbers

10400: END IF;
10401:
10402: l_progress := '610';
10403:
10404: UPDATE mtl_serial_numbers
10405: SET group_mark_id = l_txn_header_id
10406: WHERE inventory_item_id = l_item_id
10407: AND current_organization_id = p_org_id
10408: AND serial_number IN(SELECT fm_serial_number

Line 10409: FROM mtl_serial_numbers_temp

10405: SET group_mark_id = l_txn_header_id
10406: WHERE inventory_item_id = l_item_id
10407: AND current_organization_id = p_org_id
10408: AND serial_number IN(SELECT fm_serial_number
10409: FROM mtl_serial_numbers_temp
10410: WHERE transaction_temp_id = l_local_temp_id);
10411:
10412: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10413: SELECT count(MSNT.transaction_temp_id)

Line 10415: FROM Mtl_Serial_Numbers_Temp MSNT

10411:
10412: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10413: SELECT count(MSNT.transaction_temp_id)
10414: INTO l_serial_count
10415: FROM Mtl_Serial_Numbers_Temp MSNT
10416: WHERE MSNT.fm_serial_number = l_fm_serial;
10417:
10418: /*Bug#3957819.IF the serial number is already used , throw an error*/
10419: IF l_serial_count > 1 THEN

Line 11628: FROM mtl_serial_numbers

11624: , current_organization_id
11625: , inventory_item_id
11626: , group_mark_id
11627: , lpn_id
11628: FROM mtl_serial_numbers
11629: WHERE lpn_id = rec_child_lpns_csr.lpn_id;
11630:
11631: END LOOP;
11632: END IF;

Line 12219: UPDATE mtl_serial_numbers

12215: mydebug('pick_drop: group_mark_id :' || rec_msn_stg_mov_csr.transaction_temp_id);
12216: mydebug('pick_drop: lpn_id :' || rec_msn_stg_mov_csr.lpn_id);
12217: END IF;
12218:
12219: UPDATE mtl_serial_numbers
12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id

Line 12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id

12216: mydebug('pick_drop: lpn_id :' || rec_msn_stg_mov_csr.lpn_id);
12217: END IF;
12218:
12219: UPDATE mtl_serial_numbers
12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;

Line 12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number

12217: END IF;
12218:
12219: UPDATE mtl_serial_numbers
12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12225:

Line 12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id

12218:
12219: UPDATE mtl_serial_numbers
12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12225:
12226: END LOOP;

Line 12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id

12219: UPDATE mtl_serial_numbers
12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12225:
12226: END LOOP;
12227:

Line 12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;

12220: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12221: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12222: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12223: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12224: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12225:
12226: END LOOP;
12227:
12228: END LOOP;

Line 12813: FROM mtl_serial_numbers_temp msnt

12809: CURSOR c_fm_to_serial_number IS
12810: SELECT
12811: msnt.fm_serial_number,
12812: msnt.to_serial_number
12813: FROM mtl_serial_numbers_temp msnt
12814: WHERE msnt.transaction_temp_id = p_pick_slip_id;
12815:
12816: CURSOR c_fm_to_lot_serial_number IS
12817: SELECT

Line 12821: mtl_serial_numbers_temp msnt,

12817: SELECT
12818: msnt.fm_serial_number,
12819: msnt.to_serial_number
12820: FROM
12821: mtl_serial_numbers_temp msnt,
12822: mtl_transaction_lots_temp mtlt
12823: WHERE mtlt.transaction_temp_id = p_pick_slip_id
12824: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
12825:

Line 12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

12825:
12826: l_item_id NUMBER := NULL;
12827: l_serial_ctrl_code NUMBER;
12828: l_lot_ctrl_code NUMBER ;
12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
12831: /*6009436 End */
12832:
12833: BEGIN

Line 12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

12826: l_item_id NUMBER := NULL;
12827: l_serial_ctrl_code NUMBER;
12828: l_lot_ctrl_code NUMBER ;
12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
12831: /*6009436 End */
12832:
12833: BEGIN
12834: IF (l_debug = 1) THEN

Line 13033: UPDATE MTL_SERIAL_NUMBERS msn

13029: FETCH c_fm_to_lot_serial_number
13030: INTO l_fm_serial_number,l_to_serial_number;
13031: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
13032:
13033: UPDATE MTL_SERIAL_NUMBERS msn
13034: SET GROUP_MARK_ID=l_txn_hdr_id
13035: WHERE msn.current_organization_id=p_sign_on_org_id
13036: AND msn.inventory_item_id= l_item_id
13037: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 13042: UPDATE mtl_serial_numbers_temp

13038: l_to_serial_number;
13039: END LOOP;
13040: CLOSE c_fm_to_lot_serial_number;
13041:
13042: UPDATE mtl_serial_numbers_temp
13043: SET group_header_id= l_txn_hdr_id
13044: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
13045: FROM mtl_transaction_lots_temp
13046: WHERE transaction_temp_id= l_pick_slip_id );

Line 13055: UPDATE MTL_SERIAL_NUMBERS msn

13051: FETCH c_fm_to_serial_number
13052: INTO l_fm_serial_number,l_to_serial_number;
13053: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
13054:
13055: UPDATE MTL_SERIAL_NUMBERS msn
13056: SET GROUP_MARK_ID=l_txn_hdr_id
13057: WHERE msn.current_organization_id=p_sign_on_org_id
13058: AND msn.inventory_item_id= l_item_id
13059: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 13064: UPDATE mtl_serial_numbers_temp

13060: l_to_serial_number;
13061: END LOOP;
13062: CLOSE c_fm_to_serial_number;
13063:
13064: UPDATE mtl_serial_numbers_temp
13065: SET group_header_id= l_txn_hdr_id
13066: WHERE transaction_temp_id=l_pick_slip_id ;
13067:
13068: END IF;

Line 13434: FROM mtl_serial_numbers_temp msnt

13430: CURSOR c_fm_to_serial_number IS
13431: SELECT
13432: msnt.fm_serial_number,
13433: msnt.to_serial_number
13434: FROM mtl_serial_numbers_temp msnt
13435: WHERE msnt.transaction_temp_id = p_temp_id;
13436:
13437: CURSOR c_fm_to_lot_serial_number IS
13438: SELECT

Line 13442: mtl_serial_numbers_temp msnt,

13438: SELECT
13439: msnt.fm_serial_number,
13440: msnt.to_serial_number
13441: FROM
13442: mtl_serial_numbers_temp msnt,
13443: mtl_transaction_lots_temp mtlt
13444: WHERE mtlt.transaction_temp_id = p_temp_id
13445: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13446:

Line 13468: UPDATE mtl_serial_numbers

13464: FETCH c_fm_to_lot_serial_number
13465: INTO l_fm_serial_number,l_to_serial_number;
13466: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
13467:
13468: UPDATE mtl_serial_numbers
13469: SET group_mark_id = NULL
13470: WHERE inventory_item_id = p_item_id
13471: AND current_organization_id = p_org_id
13472: AND serial_number BETWEEN l_fm_serial_number AND

Line 13478: DELETE FROM mtl_serial_numbers_temp msnt

13474:
13475: END LOOP;
13476: CLOSE c_fm_to_lot_serial_number;
13477:
13478: DELETE FROM mtl_serial_numbers_temp msnt
13479: WHERE msnt.transaction_temp_id IN
13480: (SELECT mtlt.serial_transaction_temp_id
13481: FROM mtl_transaction_lots_temp mtlt
13482: WHERE mtlt.transaction_temp_id = p_temp_id);