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_INTERFACE_S dependencies on PO_LINE_TYPES_B

Line 2674: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --

2670: x_po_line_type_id number;
2671: x_line_num po_lines.line_num%type;
2672: x_po_item_id number;
2673: x_order_type_lookup_code varchar2(25);
2674: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --
2675: x_po_item_revision po_lines.item_revision%type;
2676: x_po_unit_meas_lookup_code po_lines.unit_meas_lookup_code%type;
2677: x_po_unit_price number;
2678: x_po_transaction_reason_code po_lines.transaction_reason_code%type;

Line 2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

2766: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
2767:
2768: l_return_status VARCHAR2(1);
2769:
2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

Line 2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;

2767:
2768: l_return_status VARCHAR2(1);
2769:
2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

Line 2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;

2768: l_return_status VARCHAR2(1);
2769:
2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

Line 2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;

2769:
2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

Line 2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

2770: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

Line 2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

2771: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --

Line 2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

2772: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --
2780: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --

Line 2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

2773: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --
2780: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
2781: l_type_lookup_code po_headers_all.type_lookup_code%type; --

Line 2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

2774: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
2775: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
2776: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --
2780: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
2781: l_type_lookup_code po_headers_all.type_lookup_code%type; --
2782: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --

Line 7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
7948: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
7950: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
7951: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
7952: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;

Line 8013: PO_LINE_TYPES_B plt -- Bug 3463242

8009: PO_HEADERS_INTERFACE phi,
8010: PO_REQUISITION_LINES_ALL prl, --
8011: MTL_PARAMETERS mp,
8012: HR_ORGANIZATION_INFORMATION hoi,
8013: PO_LINE_TYPES_B plt -- Bug 3463242
8014: WHERE phi.interface_header_id = p_interface_header_id
8015: AND pli.interface_header_id = phi.interface_header_id
8016: AND pli.requisition_line_id = prl.requisition_line_id(+) --
8017: AND pdi.interface_line_id = pli.interface_line_id

Line 10874: , po_line_types_b PLT --

10870: INTO x_po_line_num
10871: , x_po_line_id
10872: FROM po_lines_all POL2
10873: , po_headers_all POH
10874: , po_line_types_b PLT --
10875: WHERE POH.segment1 = x_document_num
10876: AND POH.po_header_id = POL2.po_header_id
10877: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
10878: AND POH.type_lookup_code = x_document_subtype

Line 11061: , po_line_types_b PLT --

11057: SELECT min(pli.line_num)
11058: INTO x_po_line_num
11059: FROM po_lines_interface pli
11060: , po_requisition_lines_all prl
11061: , po_line_types_b PLT --
11062: WHERE pli.interface_header_id = x_interface_header_id
11063: AND pli.line_num is not null
11064: AND prl.requisition_line_id <> x_requisition_line_id
11065: AND prl.requisition_line_id = pli.requisition_line_id

Line 11519: , po_line_types_b PLT --

11515: , po_line_id
11516: INTO x_po_line_num
11517: , x_po_line_id
11518: FROM po_lines_interface PLI
11519: , po_line_types_b PLT --
11520: WHERE pli.interface_header_id = x_interface_header_id
11521: AND pli.line_num is not null
11522: AND pli.LINE_TYPE_ID = x_line_type_id
11523: