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 1772: select 1 from pos_exasn_lots plot

1768: (
1769: plnt.lls_code in ('LAS','LOT')
1770:
1771: and exists(
1772: select 1 from pos_exasn_lots plot
1773: where plot.line_id = plnt.line_id
1774: and plot.license_plate_number is not null))
1775: or
1776: (

Line 1792: update pos_exasn_lots plot

1788: and pst.license_plate_number is not null));
1789:
1790:
1791:
1792: update pos_exasn_lots plot
1793: set (plot.product_transaction_id, plot.uom) =(select plnt.interface_transaction_id, plnt.uom
1794: from pos_exasn_lines plnt
1795: where plnt.header_id = plot.header_id
1796: and plnt.line_id = plot.line_id);

Line 2083: from pos_exasn_lots

2079: is
2080: select
2081: distinct
2082: license_plate_number
2083: from pos_exasn_lots
2084: where header_id = x_header_id
2085: and line_id = x_line_id;
2086:
2087: cursor l_LotLines_ML_csr

Line 2097: from pos_exasn_lots plot

2093: from pos_exasn_lines plnt
2094: where lls_code in ('LOT','LAS');
2095: /*
2096: and (select count(distinct nvl(license_plate_number,'null'))
2097: from pos_exasn_lots plot
2098: where plot.line_id = plnt.line_id) >1;
2099: */
2100: l_ln_header_id number;
2101:

Line 2142: from pos_exasn_lots plot

2138: if(l_lot_lpn is null) then
2139: update pos_exasn_lines plnt
2140: set plnt.quantity =
2141: (select sum(quantity)
2142: from pos_exasn_lots plot
2143: where plot.header_id = plnt.header_id
2144: and plot.line_id = plnt.line_id
2145: and plot.license_plate_number is null)
2146: where plnt.line_id = l_line_id;

Line 2151: from pos_exasn_lots plot

2147: else
2148: update pos_exasn_lines plnt
2149: set plnt.quantity =
2150: (select sum(quantity)
2151: from pos_exasn_lots plot
2152: where plot.header_id = plnt.header_id
2153: and plot.line_id = plnt.line_id
2154: and plot.license_plate_number = l_lot_lpn)
2155: where plnt.line_id = l_line_id;

Line 2161: from pos_exasn_lots

2157: else
2158: if(l_lot_lpn is null) then
2159: select sum(quantity)
2160: into l_lot_lpn_sum
2161: from pos_exasn_lots
2162: where header_id = l_ln_header_id
2163: and line_id = l_line_id
2164: and license_plate_number is null;
2165: else

Line 2168: from pos_exasn_lots

2164: and license_plate_number is null;
2165: else
2166: select sum(quantity)
2167: into l_lot_lpn_sum
2168: from pos_exasn_lots
2169: where header_id = l_ln_header_id
2170: and line_id = l_line_id
2171: and license_plate_number = l_lot_lpn;
2172: end if;

Line 2177: update pos_exasn_lots

2173:
2174: CreateNewLine(l_lot_lpn_sum, l_lot_lpn, l_new_line, l_line_id);
2175:
2176: if(l_lot_lpn is null) then
2177: update pos_exasn_lots
2178: set line_id = l_new_line
2179: where line_id = l_line_id
2180: and license_plate_number is null;
2181:

Line 2185: from pos_exasn_lots

2181:
2182: update pos_exasn_serials
2183: set line_id = l_new_line
2184: where lot_id in(select lot_id
2185: from pos_exasn_lots
2186: where line_id = l_new_line
2187: and license_plate_number is null);
2188:
2189: else

Line 2190: update pos_exasn_lots

2186: where line_id = l_new_line
2187: and license_plate_number is null);
2188:
2189: else
2190: update pos_exasn_lots
2191: set line_id = l_new_line
2192: where line_id = l_line_id
2193: and license_plate_number = l_lot_lpn;
2194:

Line 2198: from pos_exasn_lots

2194:
2195: update pos_exasn_serials
2196: set line_id = l_new_line
2197: where lot_id in (select lot_id
2198: from pos_exasn_lots
2199: where line_id = l_new_line
2200: and license_plate_number = l_lot_lpn);
2201: end if;
2202:

Line 2211: from pos_exasn_lots

2207: close l_distinctLpn_lot_csr;
2208:
2209: select sum(quantity)
2210: into l_total_lot_qty
2211: from pos_exasn_lots
2212: where header_id = l_ln_header_id
2213: and line_id >= l_line_id;--All lines created at this moment, with line_id > l_line_id is for l_line_id
2214:
2215: if(l_total_lot_qty < l_ln_quantity) then

Line 2228: from pos_exasn_lots plot2

2224: close l_LotLines_ML_csr;
2225: /*
2226: update pos_exasn_lines plnt
2227: set license_plate_number = (select distinct plot2.license_plate_number
2228: from pos_exasn_lots plot2
2229: where plot2.line_id = plnt.line_id
2230: and plot2.license_plate_number is not null)
2231: where lls_code = 'LOT'
2232: and (select count(distinct plot.license_plate_number)

Line 2233: from pos_exasn_lots plot

2229: where plot2.line_id = plnt.line_id
2230: and plot2.license_plate_number is not null)
2231: where lls_code = 'LOT'
2232: and (select count(distinct plot.license_plate_number)
2233: from pos_exasn_lots plot
2234: where plot.line_id = plnt.line_id
2235: and plot.license_plate_number is not null) = 1;
2236: */
2237: end CreateRTI4Lot;

Line 2323: from pos_exasn_lots plot,

2319: plot.NATTRIBUTE7,
2320: plot.NATTRIBUTE8,
2321: plot.NATTRIBUTE9,
2322: plot.NATTRIBUTE10
2323: from pos_exasn_lots plot,
2324: pos_exasn_lines plnt
2325: where plot.line_id = plnt.line_id;
2326:
2327: cursor l_allSerials_csr

Line 2400: l_lot_number pos_exasn_lots.lot_number%type;

2396: pos_exasn_lines plnt
2397: where plnt.line_id = plpn.line_id;
2398: l_txn_intf_id number;
2399: l_ser_intf_id number;
2400: l_lot_number pos_exasn_lots.lot_number%type;
2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;

Line 2401: l_vendor_id pos_exasn_lots.vendor_id%type;

2397: where plnt.line_id = plpn.line_id;
2398: l_txn_intf_id number;
2399: l_ser_intf_id number;
2400: l_lot_number pos_exasn_lots.lot_number%type;
2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;

Line 2402: l_grade_code pos_exasn_lots.grade_code%type;

2398: l_txn_intf_id number;
2399: l_ser_intf_id number;
2400: l_lot_number pos_exasn_lots.lot_number%type;
2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;

Line 2403: l_origination_date pos_exasn_lots.origination_date%type;

2399: l_ser_intf_id number;
2400: l_lot_number pos_exasn_lots.lot_number%type;
2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;

Line 2404: l_date_code pos_exasn_lots.date_code%type;

2400: l_lot_number pos_exasn_lots.lot_number%type;
2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;

Line 2405: l_status_id pos_exasn_lots.status_id%type;

2401: l_vendor_id pos_exasn_lots.vendor_id%type;
2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;

Line 2406: l_change_date pos_exasn_lots.change_date%type;

2402: l_grade_code pos_exasn_lots.grade_code%type;
2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;

Line 2407: l_age pos_exasn_lots.age%type;

2403: l_origination_date pos_exasn_lots.origination_date%type;
2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;

Line 2408: l_retest_date pos_exasn_lots.retest_date%type;

2404: l_date_code pos_exasn_lots.date_code%type;
2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;

Line 2409: l_maturity_date pos_exasn_lots.maturity_date%type;

2405: l_status_id pos_exasn_lots.status_id%type;
2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;

Line 2410: l_item_size pos_exasn_lots.item_size%type;

2406: l_change_date pos_exasn_lots.change_date%type;
2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;

Line 2411: l_color pos_exasn_lots.color%type;

2407: l_age pos_exasn_lots.age%type;
2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;

Line 2412: l_volume pos_exasn_lots.volume%type;

2408: l_retest_date pos_exasn_lots.retest_date%type;
2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;

Line 2413: l_volume_uom pos_exasn_lots.volume_uom%type;

2409: l_maturity_date pos_exasn_lots.maturity_date%type;
2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;

Line 2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;

2410: l_item_size pos_exasn_lots.item_size%type;
2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;

Line 2415: l_best_by_date pos_exasn_lots.best_by_date%type;

2411: l_color pos_exasn_lots.color%type;
2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;

Line 2416: l_length pos_exasn_lots.length%type;

2412: l_volume pos_exasn_lots.volume%type;
2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;

Line 2417: l_length_uom pos_exasn_lots.length_uom%type;

2413: l_volume_uom pos_exasn_lots.volume_uom%type;
2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;

Line 2418: l_recycled_content pos_exasn_lots.recycled_content%type;

2414: l_place_of_origin pos_exasn_lots.place_of_origin%type;
2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;

Line 2419: l_thickness pos_exasn_lots.thickness%type;

2415: l_best_by_date pos_exasn_lots.best_by_date%type;
2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;

Line 2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;

2416: l_length pos_exasn_lots.length%type;
2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;

Line 2421: l_width pos_exasn_lots.width%type;

2417: l_length_uom pos_exasn_lots.length_uom%type;
2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;

Line 2422: l_width_uom pos_exasn_lots.width_uom%type;

2418: l_recycled_content pos_exasn_lots.recycled_content%type;
2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;
2426: l_vendor_name pos_exasn_lots.vendor_name%type;

Line 2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;

2419: l_thickness pos_exasn_lots.thickness%type;
2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;
2426: l_vendor_name pos_exasn_lots.vendor_name%type;
2427: l_qty number;

Line 2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;

2420: l_thickness_uom pos_exasn_lots.thickness_uom%type;
2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;
2426: l_vendor_name pos_exasn_lots.vendor_name%type;
2427: l_qty number;
2428: l_po_line_loc_id number;

Line 2425: l_territory_code pos_exasn_lots.territory_code%type;

2421: l_width pos_exasn_lots.width%type;
2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;
2426: l_vendor_name pos_exasn_lots.vendor_name%type;
2427: l_qty number;
2428: l_po_line_loc_id number;
2429: l_pdt_txn_id number;

Line 2426: l_vendor_name pos_exasn_lots.vendor_name%type;

2422: l_width_uom pos_exasn_lots.width_uom%type;
2423: l_curl_wrinkle_fold pos_exasn_lots.curl_wrinkle_fold%type;
2424: l_supplier_lot_number pos_exasn_lots.supplier_lot_number%type;
2425: l_territory_code pos_exasn_lots.territory_code%type;
2426: l_vendor_name pos_exasn_lots.vendor_name%type;
2427: l_qty number;
2428: l_po_line_loc_id number;
2429: l_pdt_txn_id number;
2430: l_fm_serial pos_exasn_serials.from_serial%type;

Line 2451: l_txn_uom pos_exasn_lots.uom%type;

2447: l_lpn_status varchar2(1);
2448: l_lpn_msg_count number;
2449: l_lpn_msg_data varchar2(2000);
2450: l_serial_txn_temp_id number;
2451: l_txn_uom pos_exasn_lots.uom%type;
2452: l_lot_id number;
2453:
2454: l_25errors exception;
2455: l_lot_ln number;

Line 2672: update pos_exasn_lots

2668: end if;
2669: end if;
2670:
2671:
2672: update pos_exasn_lots
2673: set TRANSACTION_INTERFACE_ID = l_txn_intf_id, serial_transaction_temp_id = l_serial_txn_temp_id
2674: where lot_id = l_lot_id;
2675:
2676: if(l_lpn is not null) then

Line 2703: from pos_exasn_lots plot

2699: --update
2700: update pos_exasn_serials pst
2701: set pst.transaction_interface_id =
2702: (select plot.serial_transaction_temp_id
2703: from pos_exasn_lots plot
2704: where plot.lot_id = pst.lot_id);
2705:
2706:
2707:

Line 3501: pos_exasn_lots plot

3497: l_error_ln number;
3498: cursor l_checkLotControl_csr is
3499: select distinct plnt.line_number
3500: from pos_exasn_lines plnt,
3501: pos_exasn_lots plot
3502: where plnt.lls_code not in ('LOT','LAS')
3503: and plnt.line_id = plot.line_id;
3504:
3505: cursor l_checkSerialControl_csr is

Line 3530: from pos_exasn_lots t

3526: where a1.line_id = ln.line_id
3527: and ln.lls_code in ('LOT','LAS')
3528: and not exists
3529: ( select 1
3530: from pos_exasn_lots t
3531: where t.line_id = a1.line_id
3532: and t.license_plate_number = a1.license_plate_number)
3533: and not exists
3534: ( select 1