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_LPNS

Line 163: from pos_exasn_lpns plpn

159: IS
160: cursor l_ParentQtyNull_csr
161: is
162: select plpn.line_number
163: from pos_exasn_lpns plpn
164: where parent_lpn is null
165: and quantity is null;
166:
167:

Line 189: from pos_exasn_lines plnt, pos_exasn_lpns plpn

185:
186: cursor l_lineVsLpnQty_csr
187: is
188: select plnt.line_number
189: from pos_exasn_lines plnt, pos_exasn_lpns plpn
190: where plnt.line_id = plpn.line_id
191: group by plnt.line_number, plnt.quantity
192: having plnt.quantity <> sum(plpn.quantity)
193: and sum(plpn.quantity) > 0;

Line 230: from pos_exasn_lpns;

226:
227: cursor l_checkLpn_csr
228: is
229: select line_number, license_plate_number, parent_lpn, po_line_loc_id
230: from pos_exasn_lpns;
231:
232:
233: l_error_ln number;
234: l_is_new_lot varchar2(60);

Line 237: l_lpn pos_exasn_lpns.license_plate_number%type;

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);
241: l_cattribute1 varchar2(2000);

Line 405: update pos_exasn_lpns plpn

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:
405: update pos_exasn_lpns plpn
406: set (plpn.po_line_loc_id) = (select plnt.po_line_location_id
407: from pos_exasn_lines plnt
408: where plnt.header_id = plpn.header_id
409: and plnt.line_id = plpn.line_id);

Line 1709: select 1 from pos_exasn_lpns plpn

1705: or
1706: (
1707: plnt.lls_code = 'LPN'
1708: and exists(
1709: select 1 from pos_exasn_lpns plpn
1710: where plpn.line_id = plnt.line_id
1711: and plpn.quantity is not null))
1712: or
1713: (

Line 1891: from pos_exasn_lpns

1887: is
1888: select
1889: distinct
1890: license_plate_number
1891: from pos_exasn_lpns
1892: where header_id = x_header_id
1893: and line_id = x_line_id
1894: and quantity is not null;
1895:

Line 1906: from pos_exasn_lpns plpn

1902: from pos_exasn_lines plnt
1903: where lls_code = 'LPN';
1904: /*
1905: and (select count(distinct nvl(license_plate_number,'null'))
1906: from pos_exasn_lpns plpn
1907: where plpn.line_id = plnt.line_id
1908: and quantity is null) >1;
1909: */
1910: l_ln_header_id number;

Line 1947: from pos_exasn_lpns plpn

1943: where line_id = l_line_id;
1944:
1945: update pos_exasn_lines plnt
1946: set plnt.quantity = (select plpn.quantity
1947: from pos_exasn_lpns plpn
1948: where plpn.header_id = plnt.header_id
1949: and plpn.line_id = plnt.line_id
1950: and plpn.license_plate_number = l_lpn
1951: and plpn.quantity is not null)

Line 1957: from pos_exasn_lpns plpn

1953: else
1954:
1955: --Get LPN quantity for the the new Line
1956: select plpn.quantity into l_lpn_sum
1957: from pos_exasn_lpns plpn
1958: where plpn.license_plate_number = l_lpn
1959: and plpn.header_id = l_ln_header_id
1960: and plpn.line_id = l_line_id
1961: and plpn.quantity is not null;

Line 1965: update pos_exasn_lpns

1961: and plpn.quantity is not null;
1962:
1963: CreateNewLine(l_lpn_sum, l_lpn, l_new_line, l_line_id);
1964:
1965: update pos_exasn_lpns
1966: set line_id = l_new_line
1967: where line_id = l_line_id
1968: and license_plate_number = l_lpn;
1969:

Line 1979: from pos_exasn_lpns

1975: close l_distinctLpn_csr;
1976:
1977: select sum(quantity)
1978: into l_total_lpn_qty
1979: from pos_exasn_lpns
1980: where header_id = l_ln_header_id
1981: and line_id >= l_line_id;
1982:
1983: if(l_total_lpn_qty < l_ln_quantity) then

Line 1994: from pos_exasn_lpns plpn2

1990: close l_LpnLines_ML_csr;
1991: /*
1992: update pos_exasn_lines plnt
1993: set license_plate_number = (select distinct plpn2.license_plate_number
1994: from pos_exasn_lpns plpn2
1995: where plpn2.line_id = plnt.line_id
1996: and plpn2.license_plate_number is not null)
1997: where lls_code = 'LPN'
1998: and (select count(distinct plpn.license_plate_number)

Line 1999: from pos_exasn_lpns plpn

1995: where plpn2.line_id = plnt.line_id
1996: and plpn2.license_plate_number is not null)
1997: where lls_code = 'LPN'
1998: and (select count(distinct plpn.license_plate_number)
1999: from pos_exasn_lpns plpn
2000: where plpn.line_id = plnt.line_id
2001: and plpn.license_plate_number is not null) = 1;
2002: */
2003: end CreateRTI4Lpn;

Line 2325: from pos_exasn_lpns plpn,

2321: plpn.po_line_loc_id,
2322: plpn.parent_lpn,
2323: plnt.lpn_group_id,
2324: plpn.line_number
2325: from pos_exasn_lpns plpn,
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;

Line 2365: l_lpn pos_exasn_lpns.license_plate_number%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:
2369: l_lot_status varchar2(1);

Line 2366: l_parent_lpn pos_exasn_lpns.parent_lpn%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:
2369: l_lot_status varchar2(1);
2370: l_lot_msg_data varchar2(2000);

Line 3444: l_lpn pos_exasn_lpns.license_plate_number%type;

3440: and plnt.line_id = pst.line_id;
3441:
3442: --To Check that for all the child-parent lpn relationship, the child lpn exists
3443: --as either a parent in some other row, or as a lpn in the lot/serial/lpn row (with quantity specified)
3444: l_lpn pos_exasn_lpns.license_plate_number%type;
3445: cursor l_check_lpnref_csr
3446: is
3447: select
3448: LPN, LINE_NUM from

Line 3454: pos_exasn_lpns a1,

3450: select
3451: a1.license_plate_number LPN,
3452: a1.line_number LINE_NUM
3453: from
3454: pos_exasn_lpns a1,
3455: pos_exasn_lines ln
3456: where a1.line_id = ln.line_id
3457: and ln.lls_code in ('LOT','LAS')
3458: and not exists

Line 3465: from pos_exasn_lpns a2

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
3465: from pos_exasn_lpns a2
3466: where a2.line_id = a1.line_id
3467: and a2.parent_lpn = a1.license_plate_number)
3468:
3469: union all

Line 3475: pos_exasn_lpns a1,

3471: select
3472: a1.license_plate_number LPN,
3473: a1.line_number LINE_NUM
3474: from
3475: pos_exasn_lpns a1,
3476: pos_exasn_lines ln
3477: where a1.line_id = ln.line_id
3478: and ln.lls_code = 'SER'
3479: and not exists

Line 3486: from pos_exasn_lpns a2

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
3486: from pos_exasn_lpns a2
3487: where a2.line_id = a1.line_id
3488: and a2.parent_lpn = a1.license_plate_number)
3489:
3490: union all

Line 3498: pos_exasn_lpns a1,

3494: a1.license_plate_number LPN,
3495: a1.line_number LINE_NUM
3496:
3497: from
3498: pos_exasn_lpns a1,
3499: pos_exasn_lines ln
3500: where a1.line_id = ln.line_id
3501: and ln.lls_code = 'LPN'
3502: and a1.quantity is not null

Line 3504: from pos_exasn_lpns p

3500: where a1.line_id = ln.line_id
3501: and ln.lls_code = 'LPN'
3502: and a1.quantity is not null
3503: and exists ( select 1
3504: from pos_exasn_lpns p
3505: where p.line_id = a1.line_id
3506: and a1.quantity is not null
3507: and p.parent_lpn = a1.license_plate_number)
3508:

Line 3516: pos_exasn_lpns a1,

3512: select
3513: a1.license_plate_number LPN,
3514: a1.line_number LINE_NUM
3515: from
3516: pos_exasn_lpns a1,
3517: pos_exasn_lines ln
3518: where a1.line_id = ln.line_id
3519: and ln.lls_code = 'LPN'
3520: and a1.quantity is null

Line 3522: from pos_exasn_lpns a2

3518: where a1.line_id = ln.line_id
3519: and ln.lls_code = 'LPN'
3520: and a1.quantity is null
3521: and not exists ( select 1
3522: from pos_exasn_lpns a2
3523: where a2.line_id = a1.line_id
3524: and a1.quantity is null
3525: and a2.parent_lpn = a1.license_plate_number)
3526:

Line 4103: from pos_exasn_lpns plpn1, pos_exasn_lpns plpn2,

4099:
4100: cursor l_checkLpnContra_csr
4101: is
4102: select plpn1.line_number, plpn2.line_number
4103: from pos_exasn_lpns plpn1, pos_exasn_lpns plpn2,
4104: pos_exasn_lines plnt1, pos_exasn_lines plnt2
4105: where plpn1.license_plate_number = plpn2.license_plate_number
4106: and plpn1.parent_lpn <> plpn2.parent_lpn
4107: and plnt1.line_id = plpn1.line_id