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_ASN_CREATE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 120: po_line_locations_all plla

116: into
117: l_org_id,
118: l_inventory_item_id
119: from po_lines_all pla,
120: po_line_locations_all plla
121: where plla.line_location_id = p_po_line_loc_id
122: and pla.po_line_id = plla.po_line_id;
123:
124: l_progress := '001'||p_po_line_loc_id;

Line 339: po_line_locations_all plla

335: l_inventory_item_id
336: --l_uom
337: from
338: po_lines_all pla,
339: po_line_locations_all plla
340: where plla.line_location_id = p_po_line_loc_id
341: and plla.po_line_id = pla.po_line_id;
342:
343: l_uom := po_uom_s.get_primary_uom(l_inventory_item_id,l_org_id,p_transaction_uom);

Line 492: from po_line_locations_all plla

488:
489: BEGIN
490: select plla.ship_to_organization_id
491: into l_org_id
492: from po_line_locations_all plla
493: where line_location_id = p_po_line_loc_id;
494:
495: if(p_parent_license_plate_number is null) then
496: --Parent LPN is null ==> Insert LPN record, if not exist yet

Line 613: po_line_locations_all plla

609: l_val_mode
610: from
611: po_lines_all pla,
612: mtl_system_items msi,
613: po_line_locations_all plla
614: where pla.item_id = msi.inventory_item_id
615: and plla.ship_to_organization_id = msi.organization_id
616: and plla.line_location_id = p_line_loc_id
617: and plla.po_line_id = pla.po_line_id;

Line 672: po_line_locations_all plla

668: plla.ship_to_organization_id
669: into
670: l_org_id
671: from
672: po_line_locations_all plla
673: where plla.line_location_id = p_line_loc_id;
674:
675: l_ans := inv_rcv_integration_apis.validate_lpn
676: (p_api_version => 1.0

Line 785: po_line_locations_all plla

781: l_item_id,
782: l_exp_date
783: from
784: po_lines_all pla,
785: po_line_locations_all plla
786: where plla.line_location_id = p_line_loc_id
787: and plla.po_line_id = pla.po_line_id;
788:
789: l_c_attributes_tbl(1) := p_c_attributes_tbl(1);

Line 899: l_org_id po_line_locations_all.ship_to_organization_id%type;

895: l_progress varchar2(20) := '000';
896: l_lot_code mtl_system_items.lot_control_code%type;
897: l_serial_code mtl_system_items.serial_number_control_code%type;
898: l_item_id number;
899: l_org_id po_line_locations_all.ship_to_organization_id%type;
900: BEGIN
901: l_progress := '001'||p_line_location_id;
902:
903: select pla.item_id,

Line 907: from po_lines_all pla ,po_line_locations_all plla

903: select pla.item_id,
904: plla.ship_to_organization_id
905: into l_item_id,
906: l_org_id
907: from po_lines_all pla ,po_line_locations_all plla
908: where plla.line_location_id = p_line_location_id
909: and pla.po_line_id=plla.po_line_id
910: and pla.po_header_id=plla.po_header_id ;
911:

Line 1128: FROM po_line_locations_all pll,

1124: x_qty_rcv_tolerance,
1125: x_qty_rcv_exception_code,
1126: x_item_id,
1127: x_po_uom
1128: FROM po_line_locations_all pll,
1129: po_lines_all pl
1130: WHERE pll.line_location_id = p_line_location_id
1131: AND pll.po_line_id = pl.po_line_id;
1132:

Line 1248: FROM po_line_locations_all pll,

1244: SELECT pl.item_id,
1245: pl.unit_meas_lookup_code
1246: INTO x_item_id,
1247: x_po_uom
1248: FROM po_line_locations_all pll,
1249: po_lines_all pl
1250: WHERE pll.line_location_id = p_line_location_id
1251: AND pll.po_line_id = pl.po_line_id;
1252:

Line 1298: from po_line_locations_all poll,

1294: INTO l_po_uom_code
1295: FROM mtl_units_of_measure
1296: WHERE unit_of_measure =
1297: ( select nvl(poll.UNIT_MEAS_LOOKUP_CODE, pol.UNIT_MEAS_LOOKUP_CODE)
1298: from po_line_locations_all poll,
1299: po_lines_all pol
1300: where poll.line_location_id = p_line_location_id
1301: and poll.po_line_id = pol.po_line_id );
1302:

Line 1458: po_line_locations_all pll

1454:
1455: select count(*)
1456: into l_rows
1457: from rcv_transactions_interface rti, po_headers_all poh, po_releases_all por,
1458: po_line_locations_all pll
1459: where rti.po_header_id = poh.po_header_id
1460: and rti.po_release_id = por.po_release_id(+)
1461: and rti.po_line_location_id = pll.line_location_id
1462: and rti.INTERFACE_TRANSACTION_ID = p_asn_line_id

Line 1471: wms_license_plate_numbers wlpn, po_line_locations_all pll

1467:
1468: select count(*)
1469: into l_rows
1470: from rcv_shipment_lines rsl, po_headers_all poh, po_releases_all por,
1471: wms_license_plate_numbers wlpn, po_line_locations_all pll
1472: where rsl.po_header_id = poh.po_header_id
1473: and rsl.po_release_id = por.po_release_id(+)
1474: and rsl.ASN_LPN_ID = wlpn.LPN_ID
1475: and rsl.po_line_location_id = pll.line_location_id

Line 1620: FROM po_line_locations_all pll, --

1616: x_qty_rcv_tolerance,
1617: x_qty_rcv_exception_code,
1618: x_item_id,
1619: x_po_uom
1620: FROM po_line_locations_all pll, --
1621: po_lines_all pl --
1622: WHERE pll.line_location_id = p_line_location_id
1623: AND pll.po_line_id = pl.po_line_id;
1624:

Line 1787: FROM po_line_locations_all pll,

1783: INTO x_quantity_shipped,
1784: x_qty_rcv_exception_code,
1785: x_item_id,
1786: x_po_uom
1787: FROM po_line_locations_all pll,
1788: po_lines_all pl
1789: WHERE pll.line_location_id = p_line_location_id
1790: AND pll.po_line_id = pl.po_line_id;
1791: