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_LINES_ALL

Line 119: from po_lines_all pla,

115: pla.item_id
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:

Line 325: l_uom po_lines_all.UNIT_MEAS_LOOKUP_CODE%type;

321: l_org_id number;
322: l_inventory_item_id number;
323: l_expiration_date date;
324: l_serial_txn_temp_id number;
325: l_uom po_lines_all.UNIT_MEAS_LOOKUP_CODE%type;
326: BEGIN
327: -- Bug 7476612 - Start
328: select
329: plla.ship_to_organization_id,

Line 337: po_lines_all pla,

333: l_org_id,
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:

Line 610: po_lines_all pla,

606: l_item_id,
607: l_revision,
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

Line 783: po_lines_all pla,

779: l_org_id,
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:

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 1128: po_lines_all pl

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:
1132:

Line 1248: po_lines_all pl

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:
1252:

Line 1298: po_lines_all pol

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:
1302: INV_CONVERT.inv_um_conversion(l_asn_uom_code,