DBA Data[Home] [Help]

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 326: l_uom po_lines_all.UNIT_MEAS_LOOKUP_CODE%type;

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

Line 338: po_lines_all pla,

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

Line 595: l_revision po_lines_all.item_revision%type; /* Bug 9734095 */

591: l_ret_data varchar2(2000);
592: l_val_mode number;
593: l_org_id number;
594: l_item_id number;
595: l_revision po_lines_all.item_revision%type; /* Bug 9734095 */
596: l_to_serial_number mtl_serial_numbers_interface.to_serial_number%type;
597: BEGIN
598: l_to_serial_number := p_to_serial_number;
599:

Line 611: po_lines_all pla,

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

Line 784: po_lines_all pla,

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

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

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

Line 1249: po_lines_all pl

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

Line 1299: po_lines_all pol

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

Line 1621: po_lines_all pl --

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

Line 1788: po_lines_all pl

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