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.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_LINES

Line 125: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;

121:
122: --
123: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
124: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
125: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
126: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
127: --
128:
129: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --

Line 268: FROM po_lines_draft_all

264: --Autocreating a PO that references a GA
265: l_progress := '050';
266: SELECT unit_meas_lookup_code
267: INTO x_po_uom
268: FROM po_lines_draft_all
269: WHERE po_line_id = p_lines.from_line_id_tbl(i)
270: AND draft_id =po_autocreate_params.g_draft_id;
271: EXCEPTION
272: WHEN OTHERS THEN

Line 329: po_lines_draft_all pol --

325: poll.secondary_unit_of_measure --
326: INTO x_line_location_id,
327: x_secondary_unit_of_measure
328: FROM po_line_locations_draft_all poll, --
329: po_lines_draft_all pol --
330: WHERE poll.po_header_id = p_lines.po_header_id_tbl(i)
331: AND pol.draft_id =po_autocreate_params.g_draft_id
332: AND poll.po_line_id = p_lines.po_line_id_tbl(i)
333: AND poll.shipment_num = p_lines.shipment_num_tbl(i)

Line 368: FROM po_lines_draft_all --

364:
365: BEGIN
366: SELECT unit_price
367: INTO x_price
368: FROM po_lines_draft_all --
369: WHERE po_line_id=p_lines.po_line_id_tbl(i)
370: AND draft_id =po_autocreate_params.g_draft_id;
371:
372: EXCEPTION

Line 648: -- 2. item-org (po_lines.taxable_flag)

644:
645: -- Get the taxable_flag based on the following priority
646: -- 1. preferences (global.po_taxable_flag)
647: -- 2. ship_to_org (x_ship_to_org_taxable_flag)
648: -- 2. item-org (po_lines.taxable_flag)
649: -- 3. PO default (po_startup_values.taxable_flag)
650: l_progress :='250';
651: x_item_org_taxable_flag := p_lines.it_taxable_flag_tbl(i);
652:

Line 1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;

1049:
1050: d_progress NUMBER;
1051: d_module VARCHAR2(100) := 'po.plsql.po_auto_line_loc_process_pvt.create_payitem_draft';
1052:
1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;

Line 1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

1050: d_progress NUMBER;
1051: d_module VARCHAR2(100) := 'po.plsql.po_auto_line_loc_process_pvt.create_payitem_draft';
1052:
1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;

Line 1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;

1051: d_module VARCHAR2(100) := 'po.plsql.po_auto_line_loc_process_pvt.create_payitem_draft';
1052:
1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;

Line 1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;

1052:
1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;

Line 1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;

1053: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

Line 1058: l_line_amount PO_LINES_ALL.amount%TYPE;

1054: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

Line 1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;

1055: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
1056: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
1057: l_line_quantity PO_LINES_ALL.quantity%TYPE;
1058: l_line_amount PO_LINES_ALL.amount%TYPE;
1059: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
1060: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

Line 1180: FROM po_lines_draft_all pol

1176: l_line_unit_price ,
1177: l_line_quantity ,
1178: l_line_amount ,
1179: l_line_purchase_basis
1180: FROM po_lines_draft_all pol
1181: WHERE pol.po_line_id = p_lines.po_line_id_tbl(i)
1182: AND draft_id = po_autocreate_params.g_draft_id;
1183:
1184: d_progress := 30;

Line 1795: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --

1791: unexpected_create_pb_err EXCEPTION;
1792: l_ship_org_id_line mtl_system_items.organization_id%type;
1793: l_ship_org_code VARCHAR2(3);
1794: l_ship_org_name VARCHAR2(60);
1795: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
1796: l_outsourced_assembly NUMBER;
1797: x_line_location_id NUMBER;
1798: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --
1799:

Line 1870: FROM po_lines_draft_all pol

1866: --
1867: -- Get value basis from line
1868: SELECT pol.order_type_lookup_code
1869: INTO l_value_basis
1870: FROM po_lines_draft_all pol
1871: WHERE pol.po_line_id = p_lines.po_line_id_tbl(i);
1872:
1873: l_progress := '070';
1874: --