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_LINES

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 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 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 407: from pos_exasn_lines plnt

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);
410:
411: update pos_exasn_lots plot

Line 413: from pos_exasn_lines plnt

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);
416: update pos_exasn_serials pst
417: set (pst.po_line_loc_id) = (select plnt.po_line_location_id

Line 418: 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);
421:
422: open l_checkLot_csr;

Line 807: from pos_exasn_lines plnt

803: --L1: UOM
804: cursor l_checkUOM_csr
805: is
806: select plnt.line_number, plnt.uom
807: from pos_exasn_lines plnt
808: where not exists
809: (select 1 from por_unit_of_measure_lov_v puomv
810: where puomv.unit_of_measure = plnt.uom);
811:

Line 816: from pos_exasn_lines plnt

812: --L2: Country of Origin
813: cursor l_checkCountryOO_csr
814: is
815: select plnt.line_number, plnt.country_of_origin
816: from pos_exasn_lines plnt
817: where plnt.country_of_origin is not null
818: and not exists
819: (select 1 from fnd_territories_vl ftv
820: where ftv.territory_code = plnt.country_of_origin);

Line 827: from pos_exasn_lines

823: --L3/L4: Check for valid Organization Name and PO/Line/Shipment Number
824: cursor l_checkOrgName_csr
825: is
826: select line_number, operating_unit
827: from pos_exasn_lines
828: where org_id is null;
829:
830: cursor l_checkPO_csr
831: is

Line 839: from pos_exasn_lines plnt

835: plnt.po_revision,
836: plnt.po_line,
837: plnt.po_shipment,
838: plnt.operating_unit
839: from pos_exasn_lines plnt
840: where plnt.po_header_id is null
841: and plnt.po_release_num is null;
842:
843: cursor l_checkREL_csr

Line 852: from pos_exasn_lines plnt

848: plnt.po_release_num,
849: plnt.po_revision,
850: plnt.po_shipment,
851: plnt.operating_unit
852: from pos_exasn_lines plnt
853: where plnt.po_header_id is null
854: and plnt.po_release_num is not null;
855:
856: --L5: Check for Securing Attributes

Line 860: from pos_exasn_lines;

856: --L5: Check for Securing Attributes
857: cursor l_vendors_csr
858: is
859: select line_number,vendor_id
860: from pos_exasn_lines;
861:
862: cursor l_checkVendorSites_csr(x_user_id number)
863: is
864: select line_number

Line 865: from pos_exasn_lines plnt

861:
862: cursor l_checkVendorSites_csr(x_user_id number)
863: is
864: select line_number
865: from pos_exasn_lines plnt
866: where not exists(
867: select 1
868: from ak_web_user_sec_attr_values
869: WHERE web_user_id = x_user_id

Line 877: from pos_exasn_lines plnt

873:
874: cursor l_checkVendorContacts_csr(x_user_id number)
875: is
876: select line_number
877: from pos_exasn_lines plnt
878: where not exists(
879: select 1
880: from ak_web_user_sec_attr_values
881: WHERE web_user_id = x_user_id

Line 892: l_uom pos_exasn_lines.uom%type;

888: l_convQty number;
889:
890: l_primary_qty number;
891: l_line_number number;
892: l_uom pos_exasn_lines.uom%type;
893: l_po_line_location_id number;
894: l_tolerableShipQty number;
895: l_item_id number;
896: cursor l_allLines_csr

Line 899: from pos_exasn_lines;

895: l_item_id number;
896: cursor l_allLines_csr
897: is
898: select line_number, quantity, uom, po_line_location_id, item_id, header_id
899: from pos_exasn_lines;
900:
901:
902:
903: --L7: Check for existing ASN with same Shipment Number

Line 912: from pos_exasn_lines plnt,

908: select line_number, shipment_number
909: from
910: (
911: select pht.line_number, pht.shipment_number
912: from pos_exasn_lines plnt,
913: rcv_headers_interface rhi,
914: pos_exasn_headers pht
915: where pht.header_id = plnt.header_id
916: and pht.shipment_number = rhi.shipment_num

Line 921: from pos_exasn_lines plnt,

917: and plnt.vendor_id = rhi.vendor_id
918: and nvl(plnt.vendor_site_id, -9999) = nvl(rhi.vendor_site_id, -9999)
919: union
920: select plnt.line_number, pht.shipment_number
921: from pos_exasn_lines plnt,
922: rcv_shipment_headers rsh,
923: pos_exasn_headers pht
924: where pht.header_id = plnt.header_id
925: and pht.shipment_number = rsh.shipment_num

Line 979: update pos_exasn_lines plnt

975: close l_checkCountryOO_csr;
976:
977:
978: --L3: Organization Name
979: update pos_exasn_lines plnt
980: set plnt.org_id = (
981: select hou.organization_id
982: from hr_operating_units hou
983: where hou.name = plnt.operating_unit);

Line 1007: update pos_exasn_lines plnt

1003: * and allows the shipments to be used to create ASN irrespective of PO status
1004: * It also allows the shipments to be used for ASN, if the PO is in 'Requires Reapproval' status
1005: */
1006: BEGIN
1007: update pos_exasn_lines plnt
1008: set (
1009: po_header_id,
1010: po_line_id,
1011: po_line_location_id,

Line 1106: select count(1) into l_error_ln from pos_exasn_lines where po_line_location_id is null;

1102: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');
1104: END IF;
1105: END;
1106: select count(1) into l_error_ln from pos_exasn_lines where po_line_location_id is null;
1107:
1108:
1109: update pos_exasn_lines plnt
1110: set (

Line 1109: update pos_exasn_lines plnt

1105: END;
1106: select count(1) into l_error_ln from pos_exasn_lines where po_line_location_id is null;
1107:
1108:
1109: update pos_exasn_lines plnt
1110: set (
1111: po_header_id,
1112: po_release_id,
1113: po_line_id,

Line 1711: l_uom pos_exasn_lines.uom%type;

1707:
1708: procedure UpdateLinesAndLls(x_error_tbl in out NOCOPY POS_EXCELASN_ERROR_TABLE,
1709: l_error_pointer in out NOCOPY number)
1710: IS
1711: l_uom pos_exasn_lines.uom%type;
1712: l_po_line_location_id number;
1713: l_tolerableShipQty number;
1714: l_item_id number;
1715: l_quantity number;

Line 1724: from pos_exasn_lines;

1720:
1721: cursor l_allLines_csr
1722: is
1723: select line_number, quantity, uom, po_line_location_id, item_id, line_id
1724: from pos_exasn_lines;
1725:
1726: BEGIN
1727: -- Update All lines with Primary Quantity and Invoiced Quantity
1728: open l_allLines_csr;

Line 1746: update pos_exasn_lines

1742: null;
1743: end if;
1744: else
1745:
1746: update pos_exasn_lines
1747: set primary_quantity = l_primary_qty
1748: where line_id = l_line_id;
1749:
1750: update pos_exasn_lines

Line 1750: update pos_exasn_lines

1746: update pos_exasn_lines
1747: set primary_quantity = l_primary_qty
1748: where line_id = l_line_id;
1749:
1750: update pos_exasn_lines
1751: set invoiced_quantity = POS_QUANTITIES_S.get_invoice_qty
1752: (l_po_line_location_id,
1753: l_uom,
1754: l_item_id,

Line 1763: update pos_exasn_lines plnt

1759: close l_allLines_csr;
1760:
1761:
1762:
1763: update pos_exasn_lines plnt
1764: set lpn_group_id = (select pht.lpn_group_id
1765: from pos_exasn_headers pht
1766: where pht.header_id = plnt.header_id)
1767: where

Line 1794: from pos_exasn_lines plnt

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);
1797:
1798:

Line 1801: from pos_exasn_lines plnt

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);
1804:
1805: END UpdateLinesAndLls;

Line 1827: from pos_exasn_lines plnt

1823: select
1824: plnt.header_id,
1825: plnt.line_id,
1826: plnt.quantity
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

Line 1848: select max(line_id)+1 into l_new_line from pos_exasn_lines;

1844:
1845: l_line_id number;
1846:
1847: begin
1848: select max(line_id)+1 into l_new_line from pos_exasn_lines;
1849:
1850: open l_SerLines_csr;
1851: loop
1852: fetch l_SerLines_csr into

Line 1865: update pos_exasn_lines

1861: l_ser_lpn;
1862: exit when l_distinctLpn_ser_csr%NOTFOUND;
1863: if(l_first_ser = 'T') then
1864: l_first_ser := 'F';
1865: update pos_exasn_lines
1866: set license_plate_number = l_ser_lpn
1867: where line_id = l_line_id;
1868:
1869: if(l_ser_lpn is null) then

Line 1870: update pos_exasn_lines plnt

1866: set license_plate_number = l_ser_lpn
1867: where line_id = l_line_id;
1868:
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

Line 1879: update pos_exasn_lines plnt

1875: and pst.line_id = plnt.line_id
1876: and pst.license_plate_number is null)
1877: where plnt.line_id = l_line_id;
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

Line 1940: update pos_exasn_lines plnt

1936: end if;
1937: end loop;
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)

Line 1972: from pos_exasn_lines plnt

1968: select
1969: plnt.header_id,
1970: plnt.line_id,
1971: plnt.quantity
1972: from pos_exasn_lines plnt
1973: where lls_code = 'LPN';
1974: /*
1975: and (select count(distinct nvl(license_plate_number,'null'))
1976: from pos_exasn_lpns plpn

Line 1994: select max(line_id)+1 into l_new_line from pos_exasn_lines;

1990:
1991: l_line_id number;
1992:
1993: begin
1994: select max(line_id)+1 into l_new_line from pos_exasn_lines;
1995:
1996: open l_LpnLines_ML_csr;
1997: loop
1998: fetch l_LpnLines_ML_csr into

Line 2011: update pos_exasn_lines

2007: l_lpn;
2008: exit when l_distinctLpn_csr%NOTFOUND;
2009: if(l_first_lpn = 'T') then
2010: l_first_lpn := 'F';
2011: update pos_exasn_lines
2012: set license_plate_number = l_lpn
2013: where line_id = l_line_id;
2014:
2015: update pos_exasn_lines plnt

Line 2015: update pos_exasn_lines plnt

2011: update pos_exasn_lines
2012: set license_plate_number = l_lpn
2013: where line_id = l_line_id;
2014:
2015: update pos_exasn_lines plnt
2016: set plnt.quantity = (select plpn.quantity
2017: from pos_exasn_lpns plpn
2018: where plpn.header_id = plnt.header_id
2019: and plpn.line_id = plnt.line_id

Line 2062: update pos_exasn_lines plnt

2058: end if;
2059: end loop;
2060: close l_LpnLines_ML_csr;
2061: /*
2062: update pos_exasn_lines plnt
2063: set license_plate_number = (select distinct plpn2.license_plate_number
2064: from pos_exasn_lpns plpn2
2065: where plpn2.line_id = plnt.line_id
2066: and plpn2.license_plate_number is not null)

Line 2093: from pos_exasn_lines plnt

2089: select
2090: plnt.header_id,
2091: plnt.line_id,
2092: plnt.quantity
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

Line 2114: select max(line_id)+1 into l_new_line from pos_exasn_lines;

2110:
2111: l_line_id number;
2112:
2113: begin
2114: select max(line_id)+1 into l_new_line from pos_exasn_lines;
2115:
2116: open l_LotLines_ML_csr;
2117: loop
2118: fetch l_LotLines_ML_csr into

Line 2134: update pos_exasn_lines

2130:
2131: if(l_first_lot = 'T') then
2132: l_first_lot := 'F';
2133:
2134: update pos_exasn_lines
2135: set license_plate_number = l_lot_lpn
2136: where line_id = l_line_id;
2137:
2138: if(l_lot_lpn is null) then

Line 2139: update pos_exasn_lines plnt

2135: set license_plate_number = l_lot_lpn
2136: where line_id = l_line_id;
2137:
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

Line 2148: update pos_exasn_lines plnt

2144: and plot.line_id = plnt.line_id
2145: and plot.license_plate_number is null)
2146: where plnt.line_id = l_line_id;
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

Line 2226: update pos_exasn_lines plnt

2222: end if;
2223: end loop;
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)

Line 2324: pos_exasn_lines plnt

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
2328: is

Line 2383: pos_exasn_lines plnt

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:
2387: cursor l_allLpns_csr

Line 2396: pos_exasn_lines plnt

2392: plpn.parent_lpn,
2393: plnt.lpn_group_id,
2394: plpn.line_number
2395: from pos_exasn_lpns plpn,
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;

Line 2927: pos_exasn_lines plnt

2923: (
2924: select
2925: count(1), pht.header_id HEADER_ID, pht.shipment_number SHIPMENT_NUMBER, plnt.vendor_id VENDOR_ID, plnt.ship_to_org_id SHIP_TO_ORG_ID, nvl(plnt.vendor_site_id, -9999) VENDOR_SITE_ID, plnt.currency_code
2926: from pos_exasn_headers pht,
2927: pos_exasn_lines plnt
2928: where pht.header_id = plnt.header_id
2929: group by pht.header_id, pht.shipment_number, plnt.vendor_id, plnt.ship_to_org_id, nvl(plnt.vendor_site_id, -9999), plnt.currency_code
2930: )
2931: group by HEADER_ID

Line 2936: from pos_exasn_lines plnt

2932: having count(1) > 1;
2933:
2934: cursor l_createExtraRhi_csr(x_header_id number) is
2935: select distinct plnt.vendor_id VENDOR_ID, plnt.ship_to_org_id SHIP_TO_ORG_ID, nvl(plnt.vendor_site_id, -9999) VENDOR_SITE_ID, plnt.currency_code CURRENCY_CODE
2936: from pos_exasn_lines plnt
2937: where header_id = x_header_Id;
2938:
2939: l_asn_asbn varchar2(10);
2940: l_early_exit exception;

Line 3031: update pos_exasn_lines

3027:
3028: l_asn_header_id := l_asn_header_id + 1;
3029: CreateNewHeader(l_asn_header_id, l_ex_header_id, l_ex_vendor_id, l_ex_ship_to_org_id, l_ex_vendor_site_id );
3030:
3031: update pos_exasn_lines
3032: set header_id = l_asn_header_id
3033: where header_id = l_ex_header_id
3034: and vendor_id = l_ex_vendor_id
3035: and ship_to_org_id = l_ex_ship_to_org_id

Line 3066: from pos_exasn_lines plnt

3062: plnt.currency_code,
3063: plnt.rate,
3064: plnt.rate_type,
3065: plnt.rate_date
3066: from pos_exasn_lines plnt
3067: where plnt.header_id = pht.header_id
3068: and plnt.line_id =
3069: (select min(plnt2.line_id)
3070: from pos_exasn_lines plnt2

Line 3070: from pos_exasn_lines plnt2

3066: from pos_exasn_lines plnt
3067: where plnt.header_id = pht.header_id
3068: and plnt.line_id =
3069: (select min(plnt2.line_id)
3070: from pos_exasn_lines plnt2
3071: where plnt2.header_id = pht.header_id)
3072: );
3073:
3074: --H1 (Has to be done after PHT.SHIP_TO_ORG_ID is populated)

Line 3135: update pos_exasn_lines plnt

3131:
3132:
3133:
3134:
3135: update pos_exasn_lines plnt
3136: set (header_interface_id, group_id, expected_receipt_date) = (select pht.header_interface_id, pht.group_id, pht.expected_receipt_date
3137: from pos_exasn_headers pht
3138: where pht.header_id = plnt.header_id);
3139: exception when l_early_exit then

Line 3147: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );

3143: procedure CreateNewLine(p_qty in number, p_lpn in varchar2, p_line_id in number, p_old_ln in number)
3144: is
3145: l_intf_txn_id number;
3146: begin
3147: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );
3148: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;
3149: update pos_exasn_lines
3150: set (
3151: PRIMARY_UOM,

Line 3149: update pos_exasn_lines

3145: l_intf_txn_id number;
3146: begin
3147: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );
3148: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;
3149: update pos_exasn_lines
3150: set (
3151: PRIMARY_UOM,
3152: LPN_GROUP_ID,
3153: EXPECTED_RECEIPT_DATE,

Line 3346: from pos_exasn_lines

3342: SHIP_TO_LOCATION_CODE,
3343: SHIP_TO_LOCATION_ID,
3344: LLS_CODE,
3345: ITEM_DESCRIPTION
3346: from pos_exasn_lines
3347: where line_id = p_old_ln)
3348: where line_id = p_line_id;
3349: end CreateNewLine;
3350:

Line 3500: from pos_exasn_lines plnt,

3496: l_25errors exception;
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:

Line 3507: from pos_exasn_lines plnt,

3503: and plnt.line_id = plot.line_id;
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:

Line 3525: pos_exasn_lines ln

3521: a1.license_plate_number LPN,
3522: a1.line_number LINE_NUM
3523: from
3524: pos_exasn_lpns a1,
3525: pos_exasn_lines ln
3526: where a1.line_id = ln.line_id
3527: and ln.lls_code in ('LOT','LAS')
3528: and not exists
3529: ( select 1

Line 3546: pos_exasn_lines ln

3542: a1.license_plate_number LPN,
3543: a1.line_number LINE_NUM
3544: from
3545: pos_exasn_lpns a1,
3546: pos_exasn_lines ln
3547: where a1.line_id = ln.line_id
3548: and ln.lls_code = 'SER'
3549: and not exists
3550: ( select 1

Line 3569: pos_exasn_lines ln

3565: a1.line_number LINE_NUM
3566:
3567: from
3568: pos_exasn_lpns a1,
3569: pos_exasn_lines ln
3570: where a1.line_id = ln.line_id
3571: and ln.lls_code = 'LPN'
3572: and a1.quantity is not null
3573: and exists ( select 1

Line 3587: pos_exasn_lines ln

3583: a1.license_plate_number LPN,
3584: a1.line_number LINE_NUM
3585: from
3586: pos_exasn_lpns a1,
3587: pos_exasn_lines ln
3588: where a1.line_id = ln.line_id
3589: and ln.lls_code = 'LPN'
3590: and a1.quantity is null
3591: and not exists ( select 1

Line 3601: update pos_exasn_lines plnt

3597:
3598: );
3599:
3600: BEGIN
3601: update pos_exasn_lines plnt
3602: set plnt.lls_Code = 'LAS'
3603: where exists(
3604: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3605: 1 from mtl_system_items msi

Line 3611: update pos_exasn_lines plnt

3607: and msi.organization_id = plnt.ship_to_org_id
3608: and msi.lot_control_code = 2
3609: and msi.serial_number_control_code in (2,5));
3610:
3611: update pos_exasn_lines plnt
3612: set plnt.lls_Code = 'LOT'
3613: where plnt.lls_code is null
3614: and exists(
3615: select /*+ INDEX (msi, mtl_system_items_b_u1) */

Line 3622: update pos_exasn_lines plnt

3618: and msi.organization_id = plnt.ship_to_org_id
3619: and msi.lot_control_code = 2
3620: and msi.serial_number_control_code not in (2,5));
3621:
3622: update pos_exasn_lines plnt
3623: set plnt.lls_Code = 'SER'
3624: where plnt.lls_code is null
3625: and exists(
3626: select /*+ INDEX (msi, mtl_system_items_b_u1) */

Line 3633: update pos_exasn_lines plnt

3629: and msi.organization_id = plnt.ship_to_org_id
3630: and msi.lot_control_code = 1
3631: and msi.serial_number_control_code in (2,5));
3632:
3633: update pos_exasn_lines plnt
3634: set plnt.lls_Code = 'LPN'
3635: where plnt.lls_code is null;
3636:
3637:

Line 3803: from pos_exasn_lines;

3799: lpn_group_id,
3800: po_number,
3801: item_description,
3802: SHIP_TO_ORG_ID
3803: from pos_exasn_lines;
3804:
3805: end InsertIntoRTI;
3806:
3807:

Line 4178: pos_exasn_lines plnt1, pos_exasn_lines plnt2

4174: cursor l_checkLpnContra_csr
4175: is
4176: select plpn1.line_number, plpn2.line_number
4177: from pos_exasn_lpns plpn1, pos_exasn_lpns plpn2,
4178: pos_exasn_lines plnt1, pos_exasn_lines plnt2
4179: where plpn1.license_plate_number = plpn2.license_plate_number
4180: and plpn1.parent_lpn <> plpn2.parent_lpn
4181: and plnt1.line_id = plpn1.line_id
4182: and plnt2.line_id = plpn2.line_id

Line 4212: pos_exasn_lines plt,

4208: plt.po_line_location_id,
4209: pht.ship_from_location_code,
4210: ps.location_id as ship_from_location_id
4211: from pos_exasn_headers pht,
4212: pos_exasn_lines plt,
4213: hz_party_sites ps
4214: where pht.header_id = plt.header_id
4215: and pht.ship_from_location_code is not null
4216: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id

Line 4226: l_line_id pos_exasn_lines.po_line_id%type;

4222: l_return_status VARCHAR2(2000);
4223: l_prev_header_id pos_exasn_headers.header_id%type := -1;
4224: l_prev_ship_from VARCHAR2(30) := '';
4225: l_header_id pos_exasn_headers.header_id%type;
4226: l_line_id pos_exasn_lines.po_line_id%type;
4227: l_line_location_id pos_exasn_lines.po_line_location_id%type;
4228: l_ship_from_location_code pos_exasn_headers.ship_from_location_code%type;
4229: --l_ship_from_location_id hz_party_sites.location_id%type;
4230: l_ship_from_location_id number;

Line 4227: l_line_location_id pos_exasn_lines.po_line_location_id%type;

4223: l_prev_header_id pos_exasn_headers.header_id%type := -1;
4224: l_prev_ship_from VARCHAR2(30) := '';
4225: l_header_id pos_exasn_headers.header_id%type;
4226: l_line_id pos_exasn_lines.po_line_id%type;
4227: l_line_location_id pos_exasn_lines.po_line_location_id%type;
4228: l_ship_from_location_code pos_exasn_headers.ship_from_location_code%type;
4229: --l_ship_from_location_id hz_party_sites.location_id%type;
4230: l_ship_from_location_id number;
4231: l_err_tbl po_tbl_varchar2000 ;