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.POS_EXCELASN_PVT dependencies on POS_EXASN_LOTS

Line 171: from pos_exasn_lines plnt, pos_exasn_lots plot

167:
168: cursor l_LineVsLotQty_csr
169: is
170: select plnt.line_number
171: from pos_exasn_lines plnt, pos_exasn_lots plot
172: where plnt.line_id = plot.line_id
173: group by plnt.line_number, plnt.quantity
174: having plnt.quantity <> sum(plot.quantity)
175: and sum(plot.quantity) > 0;

Line 198: from pos_exasn_lots plot, pos_exasn_serials pst

194:
195: cursor l_lotVsSerialQty_csr
196: is
197: select plot.line_number
198: from pos_exasn_lots plot, pos_exasn_serials pst
199: where plot.lot_id = pst.lot_id
200: group by plot.line_number, plot.quantity
201: having plot.quantity <> sum(pst.quantity);
202:

Line 220: from pos_exasn_lots;

216: age, retest_date, maturity_date, item_size, color, volume,
217: volume_uom, place_of_origin, best_by_date, length, length_uom,
218: recycled_content, thickness, thickness_uom, width, width_uom,
219: territory_code, supplier_lot_number, vendor_name
220: from pos_exasn_lots;
221:
222: cursor l_checkSerial_csr
223: is
224: select line_number, from_serial, to_serial, quantity, license_plate_number, po_line_loc_id, lot_number

Line 236: l_lot_number pos_exasn_lots.lot_number%type;

232:
233: l_error_ln number;
234: l_is_new_lot varchar2(60);
235: l_lot_ln number;
236: l_lot_number pos_exasn_lots.lot_number%type;
237: l_lpn pos_exasn_lpns.license_plate_number%type;
238: l_po_line_loc_id number;
239:
240: l_lot_attribute_category varchar2(60);

Line 400: from pos_exasn_lots plot

396:
397: --Update lot info of Serial Records which are children of Lot Records
398: update pos_exasn_serials pst
399: set pst.lot_number = (select plot.lot_number
400: from pos_exasn_lots plot
401: where plot.header_id = pst.header_id
402: and plot.line_id = pst.line_id
403: and plot.lot_id = pst.lot_id);
404:

Line 411: update pos_exasn_lots plot

407: from pos_exasn_lines plnt
408: where plnt.header_id = plpn.header_id
409: and plnt.line_id = plpn.line_id);
410:
411: update pos_exasn_lots plot
412: set (plot.po_line_loc_id) = (select plnt.po_line_location_id
413: from pos_exasn_lines plnt
414: where plnt.header_id = plot.header_id
415: and plnt.line_id = plot.line_id);

Line 1702: select 1 from pos_exasn_lots plot

1698: (
1699: plnt.lls_code in ('LAS','LOT')
1700:
1701: and exists(
1702: select 1 from pos_exasn_lots plot
1703: where plot.line_id = plnt.line_id
1704: and plot.license_plate_number is not null))
1705: or
1706: (

Line 1722: update pos_exasn_lots plot

1718: and pst.license_plate_number is not null));
1719:
1720:
1721:
1722: update pos_exasn_lots plot
1723: set (plot.product_transaction_id, plot.uom) =(select plnt.interface_transaction_id, plnt.uom
1724: from pos_exasn_lines plnt
1725: where plnt.header_id = plot.header_id
1726: and plnt.line_id = plot.line_id);

Line 2013: from pos_exasn_lots

2009: is
2010: select
2011: distinct
2012: license_plate_number
2013: from pos_exasn_lots
2014: where header_id = x_header_id
2015: and line_id = x_line_id;
2016:
2017: cursor l_LotLines_ML_csr

Line 2027: from pos_exasn_lots plot

2023: from pos_exasn_lines plnt
2024: where lls_code in ('LOT','LAS');
2025: /*
2026: and (select count(distinct nvl(license_plate_number,'null'))
2027: from pos_exasn_lots plot
2028: where plot.line_id = plnt.line_id) >1;
2029: */
2030: l_ln_header_id number;
2031:

Line 2072: from pos_exasn_lots plot

2068: if(l_lot_lpn is null) then
2069: update pos_exasn_lines plnt
2070: set plnt.quantity =
2071: (select sum(quantity)
2072: from pos_exasn_lots plot
2073: where plot.header_id = plnt.header_id
2074: and plot.line_id = plnt.line_id
2075: and plot.license_plate_number is null)
2076: where plnt.line_id = l_line_id;

Line 2081: from pos_exasn_lots plot

2077: else
2078: update pos_exasn_lines plnt
2079: set plnt.quantity =
2080: (select sum(quantity)
2081: from pos_exasn_lots plot
2082: where plot.header_id = plnt.header_id
2083: and plot.line_id = plnt.line_id
2084: and plot.license_plate_number = l_lot_lpn)
2085: where plnt.line_id = l_line_id;

Line 2091: from pos_exasn_lots

2087: else
2088: if(l_lot_lpn is null) then
2089: select sum(quantity)
2090: into l_lot_lpn_sum
2091: from pos_exasn_lots
2092: where header_id = l_ln_header_id
2093: and line_id = l_line_id
2094: and license_plate_number is null;
2095: else

Line 2098: from pos_exasn_lots

2094: and license_plate_number is null;
2095: else
2096: select sum(quantity)
2097: into l_lot_lpn_sum
2098: from pos_exasn_lots
2099: where header_id = l_ln_header_id
2100: and line_id = l_line_id
2101: and license_plate_number = l_lot_lpn;
2102: end if;

Line 2107: update pos_exasn_lots

2103:
2104: CreateNewLine(l_lot_lpn_sum, l_lot_lpn, l_new_line, l_line_id);
2105:
2106: if(l_lot_lpn is null) then
2107: update pos_exasn_lots
2108: set line_id = l_new_line
2109: where line_id = l_line_id
2110: and license_plate_number is null;
2111:

Line 2115: from pos_exasn_lots

2111:
2112: update pos_exasn_serials
2113: set line_id = l_new_line
2114: where lot_id in(select lot_id
2115: from pos_exasn_lots
2116: where line_id = l_new_line
2117: and license_plate_number is null);
2118:
2119: else

Line 2120: update pos_exasn_lots

2116: where line_id = l_new_line
2117: and license_plate_number is null);
2118:
2119: else
2120: update pos_exasn_lots
2121: set line_id = l_new_line
2122: where line_id = l_line_id
2123: and license_plate_number = l_lot_lpn;
2124:

Line 2128: from pos_exasn_lots

2124:
2125: update pos_exasn_serials
2126: set line_id = l_new_line
2127: where lot_id in (select lot_id
2128: from pos_exasn_lots
2129: where line_id = l_new_line
2130: and license_plate_number = l_lot_lpn);
2131: end if;
2132:

Line 2141: from pos_exasn_lots

2137: close l_distinctLpn_lot_csr;
2138:
2139: select sum(quantity)
2140: into l_total_lot_qty
2141: from pos_exasn_lots
2142: where header_id = l_ln_header_id
2143: and line_id >= l_line_id;--All lines created at this moment, with line_id > l_line_id is for l_line_id
2144:
2145: if(l_total_lot_qty < l_ln_quantity) then

Line 2158: from pos_exasn_lots plot2

2154: close l_LotLines_ML_csr;
2155: /*
2156: update pos_exasn_lines plnt
2157: set license_plate_number = (select distinct plot2.license_plate_number
2158: from pos_exasn_lots plot2
2159: where plot2.line_id = plnt.line_id
2160: and plot2.license_plate_number is not null)
2161: where lls_code = 'LOT'
2162: and (select count(distinct plot.license_plate_number)

Line 2163: from pos_exasn_lots plot

2159: where plot2.line_id = plnt.line_id
2160: and plot2.license_plate_number is not null)
2161: where lls_code = 'LOT'
2162: and (select count(distinct plot.license_plate_number)
2163: from pos_exasn_lots plot
2164: where plot.line_id = plnt.line_id
2165: and plot.license_plate_number is not null) = 1;
2166: */
2167: end CreateRTI4Lot;

Line 2253: from pos_exasn_lots plot,

2249: plot.NATTRIBUTE7,
2250: plot.NATTRIBUTE8,
2251: plot.NATTRIBUTE9,
2252: plot.NATTRIBUTE10
2253: from pos_exasn_lots plot,
2254: pos_exasn_lines plnt
2255: where plot.line_id = plnt.line_id;
2256:
2257: cursor l_allSerials_csr

Line 2330: l_lot_number pos_exasn_lots.lot_number%type;

2326: pos_exasn_lines plnt
2327: where plnt.line_id = plpn.line_id;
2328: l_txn_intf_id number;
2329: l_ser_intf_id number;
2330: l_lot_number pos_exasn_lots.lot_number%type;
2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;

Line 2331: l_vendor_id pos_exasn_lots.vendor_id%type;

2327: where plnt.line_id = plpn.line_id;
2328: l_txn_intf_id number;
2329: l_ser_intf_id number;
2330: l_lot_number pos_exasn_lots.lot_number%type;
2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;

Line 2332: l_grade_code pos_exasn_lots.grade_code%type;

2328: l_txn_intf_id number;
2329: l_ser_intf_id number;
2330: l_lot_number pos_exasn_lots.lot_number%type;
2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;

Line 2333: l_origination_date pos_exasn_lots.origination_date%type;

2329: l_ser_intf_id number;
2330: l_lot_number pos_exasn_lots.lot_number%type;
2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;

Line 2334: l_date_code pos_exasn_lots.date_code%type;

2330: l_lot_number pos_exasn_lots.lot_number%type;
2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;

Line 2335: l_status_id pos_exasn_lots.status_id%type;

2331: l_vendor_id pos_exasn_lots.vendor_id%type;
2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;

Line 2336: l_change_date pos_exasn_lots.change_date%type;

2332: l_grade_code pos_exasn_lots.grade_code%type;
2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;

Line 2337: l_age pos_exasn_lots.age%type;

2333: l_origination_date pos_exasn_lots.origination_date%type;
2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;

Line 2338: l_retest_date pos_exasn_lots.retest_date%type;

2334: l_date_code pos_exasn_lots.date_code%type;
2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;

Line 2339: l_maturity_date pos_exasn_lots.maturity_date%type;

2335: l_status_id pos_exasn_lots.status_id%type;
2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;

Line 2340: l_item_size pos_exasn_lots.item_size%type;

2336: l_change_date pos_exasn_lots.change_date%type;
2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;

Line 2341: l_color pos_exasn_lots.color%type;

2337: l_age pos_exasn_lots.age%type;
2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;

Line 2342: l_volume pos_exasn_lots.volume%type;

2338: l_retest_date pos_exasn_lots.retest_date%type;
2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;

Line 2343: l_volume_uom pos_exasn_lots.volume_uom%type;

2339: l_maturity_date pos_exasn_lots.maturity_date%type;
2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;

Line 2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;

2340: l_item_size pos_exasn_lots.item_size%type;
2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;

Line 2345: l_best_by_date pos_exasn_lots.best_by_date%type;

2341: l_color pos_exasn_lots.color%type;
2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;

Line 2346: l_length pos_exasn_lots.length%type;

2342: l_volume pos_exasn_lots.volume%type;
2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;

Line 2347: l_length_uom pos_exasn_lots.length_uom%type;

2343: l_volume_uom pos_exasn_lots.volume_uom%type;
2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;

Line 2348: l_recycled_content pos_exasn_lots.recycled_content%type;

2344: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;

Line 2349: l_thickness pos_exasn_lots.thickness%type;

2345: l_best_by_date pos_exasn_lots.best_by_date%type;
2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;

Line 2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;

2346: l_length pos_exasn_lots.length%type;
2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;

Line 2351: l_width pos_exasn_lots.width%type;

2347: l_length_uom pos_exasn_lots.length_uom%type;
2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;

Line 2352: l_width_uom pos_exasn_lots.width_uom%type;

2348: l_recycled_content pos_exasn_lots.recycled_content%type;
2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;
2356: l_vendor_name pos_exasn_lots.vendor_name%type;

Line 2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;

2349: l_thickness pos_exasn_lots.thickness%type;
2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;
2356: l_vendor_name pos_exasn_lots.vendor_name%type;
2357: l_qty number;

Line 2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;

2350: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;
2356: l_vendor_name pos_exasn_lots.vendor_name%type;
2357: l_qty number;
2358: l_po_line_loc_id number;

Line 2355: l_territory_code pos_exasn_lots.territory_code%type;

2351: l_width pos_exasn_lots.width%type;
2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;
2356: l_vendor_name pos_exasn_lots.vendor_name%type;
2357: l_qty number;
2358: l_po_line_loc_id number;
2359: l_pdt_txn_id number;

Line 2356: l_vendor_name pos_exasn_lots.vendor_name%type;

2352: l_width_uom pos_exasn_lots.width_uom%type;
2353: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2354: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2355: l_territory_code pos_exasn_lots.territory_code%type;
2356: l_vendor_name pos_exasn_lots.vendor_name%type;
2357: l_qty number;
2358: l_po_line_loc_id number;
2359: l_pdt_txn_id number;
2360: l_fm_serial pos_exasn_serials.from_serial%type;

Line 2381: l_txn_uom pos_exasn_lots.uom%type;

2377: l_lpn_status varchar2(1);
2378: l_lpn_msg_count number;
2379: l_lpn_msg_data varchar2(2000);
2380: l_serial_txn_temp_id number;
2381: l_txn_uom pos_exasn_lots.uom%type;
2382: l_lot_id number;
2383:
2384: l_25errors exception;
2385: l_lot_ln number;

Line 2602: update pos_exasn_lots

2598: end if;
2599: end if;
2600:
2601:
2602: update pos_exasn_lots
2603: set TRANSACTION_INTERFACE_ID = l_txn_intf_id, serial_transaction_temp_id = l_serial_txn_temp_id
2604: where lot_id = l_lot_id;
2605:
2606: if(l_lpn is not null) then

Line 2633: from pos_exasn_lots plot

2629: --update
2630: update pos_exasn_serials pst
2631: set pst.transaction_interface_id =
2632: (select plot.serial_transaction_temp_id
2633: from pos_exasn_lots plot
2634: where plot.lot_id = pst.lot_id);
2635:
2636:
2637:

Line 3431: pos_exasn_lots plot

3427: l_error_ln number;
3428: cursor l_checkLotControl_csr is
3429: select distinct plnt.line_number
3430: from pos_exasn_lines plnt,
3431: pos_exasn_lots plot
3432: where plnt.lls_code not in ('LOT','LAS')
3433: and plnt.line_id = plot.line_id;
3434:
3435: cursor l_checkSerialControl_csr is

Line 3460: from pos_exasn_lots t

3456: where a1.line_id = ln.line_id
3457: and ln.lls_code in ('LOT','LAS')
3458: and not exists
3459: ( select 1
3460: from pos_exasn_lots t
3461: where t.line_id = a1.line_id
3462: and t.license_plate_number = a1.license_plate_number)
3463: and not exists
3464: ( select 1