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: -- Bug 14261335

Line 10162: FROM mtl_serial_numbers_temp msnt,

10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: -- Bug 14261335
10160: SELECT COUNT(msnt.transaction_temp_id)
10161: INTO l_serial_count
10162: FROM mtl_serial_numbers_temp msnt,
10163: mtl_material_transactions_temp mmtt,
10164: mtl_transaction_lots_temp mtlt
10165: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
10166: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 10214: INSERT INTO mtl_serial_numbers_temp

10210: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10211: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10212: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10213:
10214: INSERT INTO mtl_serial_numbers_temp
10215: (
10216: transaction_temp_id
10217: , last_update_date
10218: , last_updated_by

Line 10239: UPDATE mtl_serial_numbers

10235: END IF;
10236:
10237: l_progress := '520';
10238:
10239: UPDATE mtl_serial_numbers
10240: SET group_mark_id = l_txn_header_id
10241: WHERE inventory_item_id = l_item_id
10242: AND current_organization_id = p_org_id
10243: AND serial_number IN(SELECT fm_serial_number

Line 10244: FROM mtl_serial_numbers_temp msnt

10240: SET group_mark_id = l_txn_header_id
10241: WHERE inventory_item_id = l_item_id
10242: AND current_organization_id = p_org_id
10243: AND serial_number IN(SELECT fm_serial_number
10244: FROM mtl_serial_numbers_temp msnt
10245: WHERE msnt.transaction_temp_id = l_local_temp_id);
10246:
10247: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10248: -- Bug 14261335

Line 10251: FROM mtl_serial_numbers_temp msnt,

10247: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10248: -- Bug 14261335
10249: SELECT COUNT(msnt.transaction_temp_id)
10250: INTO l_serial_count
10251: FROM mtl_serial_numbers_temp msnt,
10252: mtl_material_transactions_temp mmtt
10253: WHERE mmtt.transaction_temp_id = msnt.transaction_temp_id
10254: AND mmtt.inventory_item_id = l_item_id
10255: AND mmtt.organization_id = p_org_id

Line 10321: INSERT INTO mtl_serial_numbers_temp

10317: l_new_serial_temp_id := l_lot_ser_seq;
10318: END IF;
10319:
10320: IF p_sn_allocated_flag = 'N' THEN
10321: INSERT INTO mtl_serial_numbers_temp
10322: (
10323: transaction_temp_id
10324: , last_update_date
10325: , last_updated_by

Line 10344: UPDATE mtl_serial_numbers

10340: END IF;
10341:
10342: l_progress := '570';
10343:
10344: UPDATE mtl_serial_numbers
10345: SET group_mark_id = l_txn_header_id
10346: WHERE inventory_item_id = l_item_id
10347: AND current_organization_id = p_org_id
10348: AND serial_number IN(SELECT fm_serial_number

Line 10349: FROM mtl_serial_numbers_temp

10345: SET group_mark_id = l_txn_header_id
10346: WHERE inventory_item_id = l_item_id
10347: AND current_organization_id = p_org_id
10348: AND serial_number IN(SELECT fm_serial_number
10349: FROM mtl_serial_numbers_temp
10350: WHERE transaction_temp_id = l_new_serial_temp_id);
10351:
10352: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10353: -- Bug 14261335

Line 10356: FROM mtl_serial_numbers_temp msnt,

10352: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10353: -- Bug 14261335
10354: SELECT COUNT(msnt.transaction_temp_id)
10355: INTO l_serial_count
10356: FROM mtl_serial_numbers_temp msnt,
10357: mtl_material_transactions_temp mmtt,
10358: mtl_transaction_lots_temp mtlt
10359: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
10360: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 10400: INSERT INTO mtl_serial_numbers_temp

10396: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10397: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10398: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10399:
10400: INSERT INTO mtl_serial_numbers_temp
10401: (
10402: transaction_temp_id
10403: , last_update_date
10404: , last_updated_by

Line 10425: UPDATE mtl_serial_numbers

10421: END IF;
10422:
10423: l_progress := '610';
10424:
10425: UPDATE mtl_serial_numbers
10426: SET group_mark_id = l_txn_header_id
10427: WHERE inventory_item_id = l_item_id
10428: AND current_organization_id = p_org_id
10429: AND serial_number IN(SELECT fm_serial_number

Line 10430: FROM mtl_serial_numbers_temp

10426: SET group_mark_id = l_txn_header_id
10427: WHERE inventory_item_id = l_item_id
10428: AND current_organization_id = p_org_id
10429: AND serial_number IN(SELECT fm_serial_number
10430: FROM mtl_serial_numbers_temp
10431: WHERE transaction_temp_id = l_local_temp_id);
10432:
10433: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10434: -- Bug 14261335

Line 10437: FROM mtl_serial_numbers_temp msnt,

10433: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10434: -- Bug 14261335
10435: SELECT COUNT(msnt.transaction_temp_id)
10436: INTO l_serial_count
10437: FROM mtl_serial_numbers_temp msnt,
10438: mtl_material_transactions_temp mmtt
10439: WHERE mmtt.transaction_temp_id = msnt.transaction_temp_id
10440: AND mmtt.inventory_item_id = l_item_id
10441: AND mmtt.organization_id = p_org_id

Line 11777: FROM mtl_serial_numbers

11773: , current_organization_id
11774: , inventory_item_id
11775: , group_mark_id
11776: , lpn_id
11777: FROM mtl_serial_numbers
11778: WHERE lpn_id = rec_child_lpns_csr.lpn_id;
11779:
11780: END LOOP;
11781: END IF;

Line 12396: UPDATE mtl_serial_numbers

12392: mydebug('pick_drop: group_mark_id :' || rec_msn_stg_mov_csr.transaction_temp_id);
12393: mydebug('pick_drop: lpn_id :' || rec_msn_stg_mov_csr.lpn_id);
12394: END IF;
12395:
12396: UPDATE mtl_serial_numbers
12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id

Line 12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id

12393: mydebug('pick_drop: lpn_id :' || rec_msn_stg_mov_csr.lpn_id);
12394: END IF;
12395:
12396: UPDATE mtl_serial_numbers
12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12401: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;

Line 12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number

12394: END IF;
12395:
12396: UPDATE mtl_serial_numbers
12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12401: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12402:

Line 12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id

12395:
12396: UPDATE mtl_serial_numbers
12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12401: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12402:
12403: END LOOP;

Line 12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id

12396: UPDATE mtl_serial_numbers
12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12401: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12402:
12403: END LOOP;
12404:

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

12397: SET mtl_serial_numbers.group_mark_id = rec_msn_stg_mov_csr.transaction_temp_id
12398: WHERE mtl_serial_numbers.serial_number = rec_msn_stg_mov_csr.serial_number
12399: AND mtl_serial_numbers.current_organization_id = rec_msn_stg_mov_csr.organization_id
12400: AND mtl_serial_numbers.inventory_item_id = rec_msn_stg_mov_csr.inventory_item_id
12401: AND mtl_serial_numbers.lpn_id = rec_msn_stg_mov_csr.lpn_id;
12402:
12403: END LOOP;
12404:
12405: END LOOP;

Line 13065: FROM mtl_serial_numbers_temp msnt

13061: CURSOR c_fm_to_serial_number IS
13062: SELECT
13063: msnt.fm_serial_number,
13064: msnt.to_serial_number
13065: FROM mtl_serial_numbers_temp msnt
13066: WHERE msnt.transaction_temp_id = p_pick_slip_id;
13067:
13068: CURSOR c_fm_to_lot_serial_number IS
13069: SELECT

Line 13073: mtl_serial_numbers_temp msnt,

13069: SELECT
13070: msnt.fm_serial_number,
13071: msnt.to_serial_number
13072: FROM
13073: mtl_serial_numbers_temp msnt,
13074: mtl_transaction_lots_temp mtlt
13075: WHERE mtlt.transaction_temp_id = p_pick_slip_id
13076: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13077:

Line 13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

13077:
13078: l_item_id NUMBER := NULL;
13079: l_serial_ctrl_code NUMBER;
13080: l_lot_ctrl_code NUMBER ;
13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
13083: /*6009436 End */
13084:
13085: BEGIN

Line 13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

13078: l_item_id NUMBER := NULL;
13079: l_serial_ctrl_code NUMBER;
13080: l_lot_ctrl_code NUMBER ;
13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
13083: /*6009436 End */
13084:
13085: BEGIN
13086: IF (l_debug = 1) THEN

Line 13285: UPDATE MTL_SERIAL_NUMBERS msn

13281: FETCH c_fm_to_lot_serial_number
13282: INTO l_fm_serial_number,l_to_serial_number;
13283: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
13284:
13285: UPDATE MTL_SERIAL_NUMBERS msn
13286: SET GROUP_MARK_ID=l_txn_hdr_id
13287: WHERE msn.current_organization_id=p_sign_on_org_id
13288: AND msn.inventory_item_id= l_item_id
13289: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 13294: UPDATE mtl_serial_numbers_temp

13290: l_to_serial_number;
13291: END LOOP;
13292: CLOSE c_fm_to_lot_serial_number;
13293:
13294: UPDATE mtl_serial_numbers_temp
13295: SET group_header_id= l_txn_hdr_id
13296: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
13297: FROM mtl_transaction_lots_temp
13298: WHERE transaction_temp_id= l_pick_slip_id );

Line 13307: UPDATE MTL_SERIAL_NUMBERS msn

13303: FETCH c_fm_to_serial_number
13304: INTO l_fm_serial_number,l_to_serial_number;
13305: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
13306:
13307: UPDATE MTL_SERIAL_NUMBERS msn
13308: SET GROUP_MARK_ID=l_txn_hdr_id
13309: WHERE msn.current_organization_id=p_sign_on_org_id
13310: AND msn.inventory_item_id= l_item_id
13311: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 13316: UPDATE mtl_serial_numbers_temp

13312: l_to_serial_number;
13313: END LOOP;
13314: CLOSE c_fm_to_serial_number;
13315:
13316: UPDATE mtl_serial_numbers_temp
13317: SET group_header_id= l_txn_hdr_id
13318: WHERE transaction_temp_id=l_pick_slip_id ;
13319:
13320: END IF;

Line 13687: FROM mtl_serial_numbers_temp msnt

13683: CURSOR c_fm_to_serial_number IS
13684: SELECT
13685: msnt.fm_serial_number,
13686: msnt.to_serial_number
13687: FROM mtl_serial_numbers_temp msnt
13688: WHERE msnt.transaction_temp_id = p_temp_id;
13689:
13690: CURSOR c_fm_to_lot_serial_number IS
13691: SELECT

Line 13695: mtl_serial_numbers_temp msnt,

13691: SELECT
13692: msnt.fm_serial_number,
13693: msnt.to_serial_number
13694: FROM
13695: mtl_serial_numbers_temp msnt,
13696: mtl_transaction_lots_temp mtlt
13697: WHERE mtlt.transaction_temp_id = p_temp_id
13698: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13699:

Line 13721: UPDATE mtl_serial_numbers

13717: FETCH c_fm_to_lot_serial_number
13718: INTO l_fm_serial_number,l_to_serial_number;
13719: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
13720:
13721: UPDATE mtl_serial_numbers
13722: SET group_mark_id = NULL
13723: WHERE inventory_item_id = p_item_id
13724: AND current_organization_id = p_org_id
13725: AND serial_number BETWEEN l_fm_serial_number AND

Line 13731: DELETE FROM mtl_serial_numbers_temp msnt

13727:
13728: END LOOP;
13729: CLOSE c_fm_to_lot_serial_number;
13730:
13731: DELETE FROM mtl_serial_numbers_temp msnt
13732: WHERE msnt.transaction_temp_id IN
13733: (SELECT mtlt.serial_transaction_temp_id
13734: FROM mtl_transaction_lots_temp mtlt
13735: WHERE mtlt.transaction_temp_id = p_temp_id);