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 3007: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --

3003: x_po_line_type_id number;
3004: x_line_num po_lines.line_num%type;
3005: x_po_item_id number;
3006: x_order_type_lookup_code varchar2(25);
3007: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --
3008: x_po_item_revision po_lines.item_revision%type;
3009: x_po_unit_meas_lookup_code po_lines.unit_meas_lookup_code%type;
3010: x_po_unit_price number;
3011: x_po_transaction_reason_code po_lines.transaction_reason_code%type;

Line 3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

3103: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
3104:
3105: l_return_status VARCHAR2(1);
3106:
3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

Line 3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;

3104:
3105: l_return_status VARCHAR2(1);
3106:
3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

Line 3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;

3105: l_return_status VARCHAR2(1);
3106:
3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

Line 3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;

3106:
3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

Line 3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

3107: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

Line 3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

3108: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;
3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
3116: --

Line 3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;

3109: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
3116: --
3117: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --

Line 3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

3110: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
3116: --
3117: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
3118: l_type_lookup_code po_headers_all.type_lookup_code%type; --

Line 3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

3111: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
3112: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
3116: --
3117: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
3118: l_type_lookup_code po_headers_all.type_lookup_code%type; --
3119: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --

Line 8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;

Line 8620: PO_LINE_TYPES_B plt -- Bug 3463242

8616: PO_HEADERS_INTERFACE phi,
8617: PO_REQUISITION_LINES_ALL prl, --
8618: MTL_PARAMETERS mp,
8619: HR_ORGANIZATION_INFORMATION hoi,
8620: PO_LINE_TYPES_B plt -- Bug 3463242
8621: WHERE phi.interface_header_id = p_interface_header_id
8622: AND pli.interface_header_id = phi.interface_header_id
8623: AND pli.requisition_line_id = prl.requisition_line_id(+) --
8624: AND pdi.interface_line_id = pli.interface_line_id

Line 11511: , po_line_types_b PLT --

11507: INTO x_po_line_num
11508: , x_po_line_id
11509: FROM po_lines_all POL2
11510: , po_headers_all POH
11511: , po_line_types_b PLT --
11512: WHERE POH.segment1 = x_document_num
11513: AND POH.po_header_id = POL2.po_header_id
11514: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
11515: AND POH.type_lookup_code = x_document_subtype

Line 11698: , po_line_types_b PLT --

11694: SELECT min(pli.line_num)
11695: INTO x_po_line_num
11696: FROM po_lines_interface pli
11697: , po_requisition_lines_all prl
11698: , po_line_types_b PLT --
11699: WHERE pli.interface_header_id = x_interface_header_id
11700: AND pli.line_num is not null
11701: AND prl.requisition_line_id <> x_requisition_line_id
11702: AND prl.requisition_line_id = pli.requisition_line_id

Line 12158: , po_line_types_b PLT --

12154: , po_line_id
12155: INTO x_po_line_num
12156: , x_po_line_id
12157: FROM po_lines_interface PLI
12158: , po_line_types_b PLT --
12159: WHERE pli.interface_header_id = x_interface_header_id
12160: AND pli.line_num is not null
12161: AND pli.LINE_TYPE_ID = x_line_type_id
12162: