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_SERIALS

Line 180: from pos_exasn_lines plnt, pos_exasn_serials pst

176:
177: cursor l_LineVsSerialQty_csr
178: is
179: select plnt.line_number
180: from pos_exasn_lines plnt, pos_exasn_serials pst
181: where plnt.line_id = pst.line_id
182: group by plnt.line_number, plnt.quantity
183: having plnt.quantity <> sum(pst.quantity)
184: and sum(pst.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 225: from pos_exasn_serials;

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
225: from pos_exasn_serials;
226:
227: cursor l_checkLpn_csr
228: is
229: select line_number, license_plate_number, parent_lpn, po_line_loc_id

Line 321: l_fm_serial pos_exasn_serials.from_serial%type;

317: l_ser_return_msg varchar2(2000);
318: l_lpn_status varchar2(1);
319: l_lpn_return_code varchar2(1);
320: l_lpn_return_msg varchar2(2000);
321: l_fm_serial pos_exasn_serials.from_serial%type;
322: l_to_serial pos_exasn_serials.to_serial%type;
323: l_ser_qty number;
324: l_lpn_ln number;
325: l_parent_lpn varchar2(60);

Line 322: l_to_serial pos_exasn_serials.to_serial%type;

318: l_lpn_status varchar2(1);
319: l_lpn_return_code varchar2(1);
320: l_lpn_return_msg varchar2(2000);
321: l_fm_serial pos_exasn_serials.from_serial%type;
322: l_to_serial pos_exasn_serials.to_serial%type;
323: l_ser_qty number;
324: l_lpn_ln number;
325: l_parent_lpn varchar2(60);
326: l_25errors exception;

Line 398: update pos_exasn_serials pst

394: close l_LotVsSerialQty_csr;
395:
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

Line 416: update pos_exasn_serials pst

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);
416: update pos_exasn_serials pst
417: set (pst.po_line_loc_id) = (select plnt.po_line_location_id
418: from pos_exasn_lines plnt
419: where plnt.header_id = pst.header_id
420: and plnt.line_id = pst.line_id);

Line 1716: select 1 from pos_exasn_serials pst

1712: or
1713: (
1714: plnt.lls_code = 'SER'
1715: and exists(
1716: select 1 from pos_exasn_serials pst
1717: where pst.line_id = plnt.line_id
1718: and pst.license_plate_number is not null));
1719:
1720:

Line 1729: update pos_exasn_serials pst

1725: where plnt.header_id = plot.header_id
1726: and plnt.line_id = plot.line_id);
1727:
1728:
1729: update pos_exasn_serials pst
1730: set (pst.product_transaction_id) = (select plnt.interface_transaction_id
1731: from pos_exasn_lines plnt
1732: where plnt.header_id = pst.header_id
1733: and plnt.line_id = pst.line_id);

Line 1745: from pos_exasn_serials

1741: is
1742: select
1743: distinct
1744: license_plate_number
1745: from pos_exasn_serials
1746: where header_id = x_header_id
1747: and line_id = x_line_id
1748: and lot_id = 0;
1749: --assuming lot_id = 0 ==> SER items

Line 1761: from pos_exasn_serials pst

1757: from pos_exasn_lines plnt
1758: where lls_code = 'SER';
1759: /*
1760: and (select count(distinct nvl(license_plate_number,'null'))
1761: from pos_exasn_serials pst
1762: where pst.line_id = plnt.line_id) >1;
1763: */
1764: l_ln_header_id number;
1765:

Line 1803: from pos_exasn_serials pst

1799: if(l_ser_lpn is null) then
1800: update pos_exasn_lines plnt
1801: set plnt.quantity =
1802: (select sum(quantity)
1803: from pos_exasn_serials pst
1804: where pst.header_id = plnt.header_id
1805: and pst.line_id = plnt.line_id
1806: and pst.license_plate_number is null)
1807: where plnt.line_id = l_line_id;

Line 1812: from pos_exasn_serials pst

1808: else
1809: update pos_exasn_lines plnt
1810: set plnt.quantity =
1811: (select sum(quantity)
1812: from pos_exasn_serials pst
1813: where pst.header_id = plnt.header_id
1814: and pst.line_id = plnt.line_id
1815: and pst.license_plate_number = l_ser_lpn)
1816: where plnt.line_id = l_line_id;

Line 1822: from pos_exasn_serials

1818: else
1819: if(l_ser_lpn is null) then
1820: select sum(quantity)
1821: into l_ser_lpn_sum
1822: from pos_exasn_serials
1823: where header_id = l_ln_header_id
1824: and line_id = l_line_id
1825: and license_plate_number is null;
1826: else

Line 1829: from pos_exasn_serials

1825: and license_plate_number is null;
1826: else
1827: select sum(quantity)
1828: into l_ser_lpn_sum
1829: from pos_exasn_serials
1830: where header_id = l_ln_header_id
1831: and line_id = l_line_id
1832: and license_plate_number = l_ser_lpn;
1833: end if;

Line 1838: update pos_exasn_serials

1834:
1835: CreateNewLine(l_ser_lpn_sum, l_ser_lpn, l_new_line, l_line_id);
1836:
1837: if(l_ser_lpn is null) then
1838: update pos_exasn_serials
1839: set line_id = l_new_line
1840: where line_id = l_line_id
1841: and license_plate_number is null;
1842: else

Line 1843: update pos_exasn_serials

1839: set line_id = l_new_line
1840: where line_id = l_line_id
1841: and license_plate_number is null;
1842: else
1843: update pos_exasn_serials
1844: set line_id = l_new_line
1845: where line_id = l_line_id
1846: and license_plate_number = l_ser_lpn;
1847: end if;

Line 1857: from pos_exasn_serials

1853: close l_distinctLpn_ser_csr;
1854:
1855: select sum(quantity)
1856: into l_total_ser_qty
1857: from pos_exasn_serials
1858: where header_id = l_ln_header_id
1859: and line_id >= l_line_id;
1860:
1861: if(l_total_ser_qty < l_ln_quantity) then

Line 1872: from pos_exasn_serials pst2

1868: close l_SerLines_csr;
1869: /*
1870: update pos_exasn_lines plnt
1871: set license_plate_number = (select distinct pst2.license_plate_number
1872: from pos_exasn_serials pst2
1873: where pst2.line_id = plnt.line_id
1874: and pst2.license_plate_number is not null)
1875: where lls_code = 'SER'
1876: and (select count(distinct pst.license_plate_number)

Line 1877: from pos_exasn_serials pst

1873: where pst2.line_id = plnt.line_id
1874: and pst2.license_plate_number is not null)
1875: where lls_code = 'SER'
1876: and (select count(distinct pst.license_plate_number)
1877: from pos_exasn_serials pst
1878: where pst.line_id = plnt.line_id
1879: and pst.license_plate_number is not null) = 1;
1880: */
1881: end CreateRTI4Ser;

Line 2112: update pos_exasn_serials

2108: set line_id = l_new_line
2109: where line_id = l_line_id
2110: and license_plate_number is null;
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

Line 2125: update pos_exasn_serials

2121: set line_id = l_new_line
2122: where line_id = l_line_id
2123: and license_plate_number = l_lot_lpn;
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

Line 2312: from pos_exasn_serials pst,

2308: pst.NATTRIBUTE7,
2309: pst.NATTRIBUTE8,
2310: pst.NATTRIBUTE9,
2311: pst.NATTRIBUTE10
2312: from pos_exasn_serials pst,
2313: pos_exasn_lines plnt
2314: where pst.line_id = plnt.line_id;
2315:
2316:

Line 2360: l_fm_serial pos_exasn_serials.from_serial%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;
2361: l_to_serial pos_exasn_serials.to_serial%type;
2362: l_ser_origination_date pos_exasn_serials.origination_date%type;
2363: l_ser_status_id pos_exasn_serials.status_id%type;
2364: l_ser_territory_code pos_exasn_serials.territory_code%type;

Line 2361: l_to_serial pos_exasn_serials.to_serial%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;
2361: l_to_serial pos_exasn_serials.to_serial%type;
2362: l_ser_origination_date pos_exasn_serials.origination_date%type;
2363: l_ser_status_id pos_exasn_serials.status_id%type;
2364: l_ser_territory_code pos_exasn_serials.territory_code%type;
2365: l_lpn pos_exasn_lpns.license_plate_number%type;

Line 2362: l_ser_origination_date pos_exasn_serials.origination_date%type;

2358: l_po_line_loc_id number;
2359: l_pdt_txn_id number;
2360: l_fm_serial pos_exasn_serials.from_serial%type;
2361: l_to_serial pos_exasn_serials.to_serial%type;
2362: l_ser_origination_date pos_exasn_serials.origination_date%type;
2363: l_ser_status_id pos_exasn_serials.status_id%type;
2364: l_ser_territory_code pos_exasn_serials.territory_code%type;
2365: l_lpn pos_exasn_lpns.license_plate_number%type;
2366: l_parent_lpn pos_exasn_lpns.parent_lpn%type;

Line 2363: l_ser_status_id pos_exasn_serials.status_id%type;

2359: l_pdt_txn_id number;
2360: l_fm_serial pos_exasn_serials.from_serial%type;
2361: l_to_serial pos_exasn_serials.to_serial%type;
2362: l_ser_origination_date pos_exasn_serials.origination_date%type;
2363: l_ser_status_id pos_exasn_serials.status_id%type;
2364: l_ser_territory_code pos_exasn_serials.territory_code%type;
2365: l_lpn pos_exasn_lpns.license_plate_number%type;
2366: l_parent_lpn pos_exasn_lpns.parent_lpn%type;
2367: l_lpn_Group_id number;

Line 2364: l_ser_territory_code pos_exasn_serials.territory_code%type;

2360: l_fm_serial pos_exasn_serials.from_serial%type;
2361: l_to_serial pos_exasn_serials.to_serial%type;
2362: l_ser_origination_date pos_exasn_serials.origination_date%type;
2363: l_ser_status_id pos_exasn_serials.status_id%type;
2364: l_ser_territory_code pos_exasn_serials.territory_code%type;
2365: l_lpn pos_exasn_lpns.license_plate_number%type;
2366: l_parent_lpn pos_exasn_lpns.parent_lpn%type;
2367: l_lpn_Group_id number;
2368:

Line 2630: update pos_exasn_serials pst

2626: end loop;
2627: close l_allLots_csr;
2628:
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);

Line 3438: pos_exasn_serials pst

3434:
3435: cursor l_checkSerialControl_csr is
3436: select distinct plnt.line_number
3437: from pos_exasn_lines plnt,
3438: pos_exasn_serials pst
3439: where plnt.lls_code not in ('SER','LAS')
3440: and plnt.line_id = pst.line_id;
3441:
3442: --To Check that for all the child-parent lpn relationship, the child lpn exists

Line 3481: from pos_exasn_serials s

3477: where a1.line_id = ln.line_id
3478: and ln.lls_code = 'SER'
3479: and not exists
3480: ( select 1
3481: from pos_exasn_serials s
3482: where s.line_id = a1.line_id
3483: and s.license_plate_number = a1.license_plate_number)
3484: and not exists
3485: ( select 1