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 1786: select 1 from pos_exasn_serials pst

1782: or
1783: (
1784: plnt.lls_code = 'SER'
1785: and exists(
1786: select 1 from pos_exasn_serials pst
1787: where pst.line_id = plnt.line_id
1788: and pst.license_plate_number is not null));
1789:
1790:

Line 1799: update pos_exasn_serials pst

1795: where plnt.header_id = plot.header_id
1796: and plnt.line_id = plot.line_id);
1797:
1798:
1799: update pos_exasn_serials pst
1800: set (pst.product_transaction_id) = (select plnt.interface_transaction_id
1801: from pos_exasn_lines plnt
1802: where plnt.header_id = pst.header_id
1803: and plnt.line_id = pst.line_id);

Line 1815: from pos_exasn_serials

1811: is
1812: select
1813: distinct
1814: license_plate_number
1815: from pos_exasn_serials
1816: where header_id = x_header_id
1817: and line_id = x_line_id
1818: and lot_id = 0;
1819: --assuming lot_id = 0 ==> SER items

Line 1831: from pos_exasn_serials pst

1827: from pos_exasn_lines plnt
1828: where lls_code = 'SER';
1829: /*
1830: and (select count(distinct nvl(license_plate_number,'null'))
1831: from pos_exasn_serials pst
1832: where pst.line_id = plnt.line_id) >1;
1833: */
1834: l_ln_header_id number;
1835:

Line 1873: from pos_exasn_serials pst

1869: if(l_ser_lpn is null) then
1870: update pos_exasn_lines plnt
1871: set plnt.quantity =
1872: (select sum(quantity)
1873: from pos_exasn_serials pst
1874: where pst.header_id = plnt.header_id
1875: and pst.line_id = plnt.line_id
1876: and pst.license_plate_number is null)
1877: where plnt.line_id = l_line_id;

Line 1882: from pos_exasn_serials pst

1878: else
1879: update pos_exasn_lines plnt
1880: set plnt.quantity =
1881: (select sum(quantity)
1882: from pos_exasn_serials pst
1883: where pst.header_id = plnt.header_id
1884: and pst.line_id = plnt.line_id
1885: and pst.license_plate_number = l_ser_lpn)
1886: where plnt.line_id = l_line_id;

Line 1892: from pos_exasn_serials

1888: else
1889: if(l_ser_lpn is null) then
1890: select sum(quantity)
1891: into l_ser_lpn_sum
1892: from pos_exasn_serials
1893: where header_id = l_ln_header_id
1894: and line_id = l_line_id
1895: and license_plate_number is null;
1896: else

Line 1899: from pos_exasn_serials

1895: and license_plate_number is null;
1896: else
1897: select sum(quantity)
1898: into l_ser_lpn_sum
1899: from pos_exasn_serials
1900: where header_id = l_ln_header_id
1901: and line_id = l_line_id
1902: and license_plate_number = l_ser_lpn;
1903: end if;

Line 1908: update pos_exasn_serials

1904:
1905: CreateNewLine(l_ser_lpn_sum, l_ser_lpn, l_new_line, l_line_id);
1906:
1907: if(l_ser_lpn is null) then
1908: update pos_exasn_serials
1909: set line_id = l_new_line
1910: where line_id = l_line_id
1911: and license_plate_number is null;
1912: else

Line 1913: update pos_exasn_serials

1909: set line_id = l_new_line
1910: where line_id = l_line_id
1911: and license_plate_number is null;
1912: else
1913: update pos_exasn_serials
1914: set line_id = l_new_line
1915: where line_id = l_line_id
1916: and license_plate_number = l_ser_lpn;
1917: end if;

Line 1927: from pos_exasn_serials

1923: close l_distinctLpn_ser_csr;
1924:
1925: select sum(quantity)
1926: into l_total_ser_qty
1927: from pos_exasn_serials
1928: where header_id = l_ln_header_id
1929: and line_id >= l_line_id;
1930:
1931: if(l_total_ser_qty < l_ln_quantity) then

Line 1942: from pos_exasn_serials pst2

1938: close l_SerLines_csr;
1939: /*
1940: update pos_exasn_lines plnt
1941: set license_plate_number = (select distinct pst2.license_plate_number
1942: from pos_exasn_serials pst2
1943: where pst2.line_id = plnt.line_id
1944: and pst2.license_plate_number is not null)
1945: where lls_code = 'SER'
1946: and (select count(distinct pst.license_plate_number)

Line 1947: from pos_exasn_serials pst

1943: where pst2.line_id = plnt.line_id
1944: and pst2.license_plate_number is not null)
1945: where lls_code = 'SER'
1946: and (select count(distinct pst.license_plate_number)
1947: from pos_exasn_serials pst
1948: where pst.line_id = plnt.line_id
1949: and pst.license_plate_number is not null) = 1;
1950: */
1951: end CreateRTI4Ser;

Line 2182: update pos_exasn_serials

2178: set line_id = l_new_line
2179: where line_id = l_line_id
2180: and license_plate_number is null;
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

Line 2195: update pos_exasn_serials

2191: set line_id = l_new_line
2192: where line_id = l_line_id
2193: and license_plate_number = l_lot_lpn;
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

Line 2382: from pos_exasn_serials pst,

2378: pst.NATTRIBUTE7,
2379: pst.NATTRIBUTE8,
2380: pst.NATTRIBUTE9,
2381: pst.NATTRIBUTE10
2382: from pos_exasn_serials pst,
2383: pos_exasn_lines plnt
2384: where pst.line_id = plnt.line_id;
2385:
2386:

Line 2430: l_fm_serial pos_exasn_serials.from_serial%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;
2431: l_to_serial pos_exasn_serials.to_serial%type;
2432: l_ser_origination_date pos_exasn_serials.origination_date%type;
2433: l_ser_status_id pos_exasn_serials.status_id%type;
2434: l_ser_territory_code pos_exasn_serials.territory_code%type;

Line 2431: l_to_serial pos_exasn_serials.to_serial%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;
2431: l_to_serial pos_exasn_serials.to_serial%type;
2432: l_ser_origination_date pos_exasn_serials.origination_date%type;
2433: l_ser_status_id pos_exasn_serials.status_id%type;
2434: l_ser_territory_code pos_exasn_serials.territory_code%type;
2435: l_lpn pos_exasn_lpns.license_plate_number%type;

Line 2432: l_ser_origination_date pos_exasn_serials.origination_date%type;

2428: l_po_line_loc_id number;
2429: l_pdt_txn_id number;
2430: l_fm_serial pos_exasn_serials.from_serial%type;
2431: l_to_serial pos_exasn_serials.to_serial%type;
2432: l_ser_origination_date pos_exasn_serials.origination_date%type;
2433: l_ser_status_id pos_exasn_serials.status_id%type;
2434: l_ser_territory_code pos_exasn_serials.territory_code%type;
2435: l_lpn pos_exasn_lpns.license_plate_number%type;
2436: l_parent_lpn pos_exasn_lpns.parent_lpn%type;

Line 2433: l_ser_status_id pos_exasn_serials.status_id%type;

2429: l_pdt_txn_id number;
2430: l_fm_serial pos_exasn_serials.from_serial%type;
2431: l_to_serial pos_exasn_serials.to_serial%type;
2432: l_ser_origination_date pos_exasn_serials.origination_date%type;
2433: l_ser_status_id pos_exasn_serials.status_id%type;
2434: l_ser_territory_code pos_exasn_serials.territory_code%type;
2435: l_lpn pos_exasn_lpns.license_plate_number%type;
2436: l_parent_lpn pos_exasn_lpns.parent_lpn%type;
2437: l_lpn_Group_id number;

Line 2434: l_ser_territory_code pos_exasn_serials.territory_code%type;

2430: l_fm_serial pos_exasn_serials.from_serial%type;
2431: l_to_serial pos_exasn_serials.to_serial%type;
2432: l_ser_origination_date pos_exasn_serials.origination_date%type;
2433: l_ser_status_id pos_exasn_serials.status_id%type;
2434: l_ser_territory_code pos_exasn_serials.territory_code%type;
2435: l_lpn pos_exasn_lpns.license_plate_number%type;
2436: l_parent_lpn pos_exasn_lpns.parent_lpn%type;
2437: l_lpn_Group_id number;
2438:

Line 2700: update pos_exasn_serials pst

2696: end loop;
2697: close l_allLots_csr;
2698:
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);

Line 3508: pos_exasn_serials pst

3504:
3505: cursor l_checkSerialControl_csr is
3506: select distinct plnt.line_number
3507: from pos_exasn_lines plnt,
3508: pos_exasn_serials pst
3509: where plnt.lls_code not in ('SER','LAS')
3510: and plnt.line_id = pst.line_id;
3511:
3512: --To Check that for all the child-parent lpn relationship, the child lpn exists

Line 3551: from pos_exasn_serials s

3547: where a1.line_id = ln.line_id
3548: and ln.lls_code = 'SER'
3549: and not exists
3550: ( select 1
3551: from pos_exasn_serials s
3552: where s.line_id = a1.line_id
3553: and s.license_plate_number = a1.license_plate_number)
3554: and not exists
3555: ( select 1