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 338: po_line_locations_all plla

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

Line 491: from po_line_locations_all plla

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

Line 612: po_line_locations_all plla

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

Line 671: po_line_locations_all plla

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

Line 784: po_line_locations_all plla

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

Line 898: l_org_id po_line_locations_all.ship_to_organization_id%type;

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

Line 906: from po_lines_all pla ,po_line_locations_all plla

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

Line 1127: FROM po_line_locations_all pll,

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

Line 1247: FROM po_line_locations_all pll,

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

Line 1297: from po_line_locations_all poll,

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

Line 1457: po_line_locations_all pll

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

Line 1470: wms_license_plate_numbers wlpn, po_line_locations_all pll

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