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_PROCESS_PVT dependencies on PO_LINE_TYPES

Line 282: po_line_types plt

278: phi.document_subtype,
279: pli.unit_price
280: FROM po_lines_interface pli,
281: po_headers_interface phi,
282: po_line_types plt
283: WHERE phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
284: AND phi.interface_header_id = pli.interface_header_id
285: AND pli.requisition_line_id IS NULL
286: AND plt.line_type_id = pli.line_type_id

Line 501: po_line_types plt

497: NVL(pli.cost_constraint,prl.cost_constraint)
498: FROM po_lines_interface pli,
499: po_headers_interface phi,
500: po_requisition_lines_all prl,
501: po_line_types plt
502: WHERE pli.interface_line_id = pli2.interface_line_id
503: AND pli.interface_header_id = phi.interface_header_id
504: AND phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
505: AND pli.requisition_line_id = prl.requisition_line_id(+)

Line 1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

1674: --
1675: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
1676: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1677: l_return_status VARCHAR2(1);
1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

Line 1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;

1675: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
1676: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1677: l_return_status VARCHAR2(1);
1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

Line 1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;

1676: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1677: l_return_status VARCHAR2(1);
1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

Line 1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;

1677: l_return_status VARCHAR2(1);
1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

Line 1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

Line 1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
1687: --

Line 1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

1680: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
1687: --
1688: l_db_quantity NUMBER;

Line 1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

1681: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
1687: --
1688: l_db_quantity NUMBER;
1689: l_min_shipment_num NUMBER;

Line 1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

1682: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
1683: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
1684: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
1685: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
1686: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
1687: --
1688: l_db_quantity NUMBER;
1689: l_min_shipment_num NUMBER;
1690: l_need_by_date DATE;

Line 1704: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE;

1700: x_po_line_type_id NUMBER;
1701: x_line_num po_lines.line_num%type;
1702: x_po_item_id NUMBER;
1703: x_order_type_lookup_code VARCHAR2(25);
1704: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE;
1705: x_po_item_revision po_lines.item_revision%type;
1706: x_po_unit_meas_lookup_code po_lines.unit_meas_lookup_code%type;
1707: x_po_unit_price NUMBER;
1708: x_po_transaction_reason_code po_lines.transaction_reason_code%type;

Line 1717: x_unit_of_measure po_line_types.unit_of_measure%type:=NULL;

1713: x_result VARCHAR2(7);
1714: update_req_pool_fail EXCEPTION;
1715: x_hazard_class_id NUMBER :=NULL;
1716: x_un_number_id NUMBER :=NULL;
1717: x_unit_of_measure po_line_types.unit_of_measure%type:=NULL;
1718: --The following flag indicates whether copying the attachments from (all)the
1719: --sourcing entities need to be suppressed due to the grouping of lines.
1720: x_attch_suppress_flag VARCHAR2(1) :='N';
1721: l_enhanced_pricing_flag po_doc_style_headers.enhanced_pricing_flag%type;

Line 1911: FROM po_line_types

1907: SELECT order_type_lookup_code,
1908: purchase_basis
1909: INTO x_order_type_lookup_code,
1910: l_purchase_basis
1911: FROM po_line_types
1912: WHERE line_type_id = p_lines.line_type_id_tbl (i);
1913:
1914: IF g_debug_stmt THEN
1915: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

Line 2243: FROM po_line_types_v

2239: SELECT NVL(p_lines.it_rcv_tolerance_tbl(i),receipt_close),
2240: NVL(p_lines.it_receipt_req_flag_tbl(i),receiving_flag)
2241: INTO p_lines.it_rcv_tolerance_tbl(i),
2242: p_lines.it_receipt_req_flag_tbl(i)
2243: FROM po_line_types_v
2244: WHERE line_type_id = p_lines.line_type_id_tbl(i);
2245:
2246: EXCEPTION
2247: WHEN no_data_found THEN

Line 2457: FROM po_line_types

2453: BEGIN
2454: l_progress:='270';
2455: SELECT unit_of_measure
2456: INTO x_unit_of_measure
2457: FROM po_line_types
2458: WHERE line_type_id= p_lines.line_type_id_tbl(i);
2459: EXCEPTION
2460: WHEN OTHERS THEN
2461: IF g_debug_unexp THEN

Line 2483: FROM po_line_types

2479: BEGIN
2480: l_progress:='285';
2481: SELECT unit_of_measure
2482: INTO x_unit_of_measure
2483: FROM po_line_types
2484: WHERE line_type_id = p_lines.line_type_id_tbl(i);
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: IF g_debug_unexp THEN

Line 2655: PO_LINE_TYPES_SV.get_line_type_def( p_lines.line_type_id_tbl(i),

2651: -- Retrieve the values for order_type_lookup_code, purchase_basis
2652: -- and matching_basis
2653: IF NVL(p_lines.clm_info_flag_tbl(i),'N') <> 'Y' THEN
2654: l_progress := '380';
2655: PO_LINE_TYPES_SV.get_line_type_def( p_lines.line_type_id_tbl(i),
2656: l_order_type_lookup_code,
2657: l_purchase_basis1,
2658: l_matching_basis,
2659: l_category_id,

Line 5050: po_line_types_b plb

5046: (SELECT requisition_line_id, Sum(prd.funds_remaining) AS tot_funds_remaining
5047: FROM po_clmreq_dist_details_v prd
5048: GROUP BY prd.requisition_line_id) req_dist_amt,
5049: po_requisition_lines_all prl,
5050: po_line_types_b plb
5051: WHERE phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
5052: AND pli.interface_header_id = phi.interface_header_id
5053: AND Nvl(pli.orig_from_req_flag, 'N') = 'S'
5054: AND pli.bid_number = paa.bid_number