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_B

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