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

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 2746: x_unit_of_measure po_line_types.unit_of_measure%type:=null;

2742: x_result varchar2(7);
2743: update_req_pool_fail exception;
2744: x_hazard_class_id number:=null;
2745: x_un_number_id number:=null;
2746: x_unit_of_measure po_line_types.unit_of_measure%type:=null;
2747: --The following flag indicates whether copying the attachments from (all)the
2748: --sourcing entities need to be suppressed due to the grouping of lines.
2749: x_attch_suppress_flag varchar2(1) :='N';
2750: --

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 2899: FROM po_line_types

2895: SELECT order_type_lookup_code
2896: , purchase_basis --
2897: INTO x_order_type_lookup_code
2898: , l_purchase_basis --
2899: FROM po_line_types
2900: WHERE line_type_id = interface.line_type_id;
2901: END IF; -- Bug 586033, lpo, 11/25/97
2902:
2903: l_progress := '020';

Line 3319: FROM po_line_types_v

3315: SELECT nvl(item.receive_close_tolerance,receipt_close),
3316: nvl(item.receipt_required_flag,receiving_flag)
3317: INTO item.receive_close_tolerance,
3318: item.receipt_required_flag
3319: FROM po_line_types_v
3320: WHERE line_type_id = interface.line_type_id;
3321: exception
3322: when no_data_found then
3323: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 3653: from po_line_types

3649: begin
3650: l_progress:='280';
3651: select unit_of_measure
3652: into x_unit_of_measure
3653: from po_line_types
3654: where line_type_id= interface.line_type_id;
3655: exception
3656: when others then
3657: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >

Line 3827: PO_LINE_TYPES_SV.get_line_type_def(

3823: l_progress := '380';
3824: --
3825: -- Retrieve the values for order_type_lookup_code, purchase_basis
3826: -- and matching_basis
3827: PO_LINE_TYPES_SV.get_line_type_def(
3828: interface.line_type_id,
3829: l_order_type_lookup_code,
3830: l_purchase_basis1,
3831: l_matching_basis,

Line 4339: FROM po_line_types_v

4335: SELECT nvl(item.receive_close_tolerance,receipt_close),
4336: nvl(item.receipt_required_flag,receiving_flag)
4337: INTO item.receive_close_tolerance,
4338: item.receipt_required_flag
4339: FROM po_line_types_v
4340: WHERE line_type_id = interface.line_type_id;
4341: exception
4342: when no_data_found then
4343: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 5301: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --

5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5299: --
5300:
5301: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --
5302:
5303: BEGIN
5304: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
5305: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

Line 5321: FROM po_line_types plt

5317: -- : Also get matching basis
5318:
5319: SELECT plt.order_type_lookup_code, plt.matching_basis
5320: INTO x_order_type_lookup_code, l_matching_basis
5321: FROM po_line_types plt
5322: WHERE plt.line_type_id = interface.line_type_id;
5323:
5324: --
5325: --

Line 6568: FROM po_line_types

6564:
6565: l_progress := '030';
6566: SELECT order_type_lookup_code
6567: INTO x_order_type_lookup_code
6568: FROM po_line_types
6569: WHERE line_type_id = interface.line_type_id;
6570:
6571: l_progress := '040';
6572: SELECT set_of_books_id

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 8680: po_line_types plt

8676: phi.document_subtype,
8677: pli.unit_price --
8678: FROM po_lines_interface pli,
8679: po_headers_interface phi,
8680: po_line_types plt
8681: WHERE phi.interface_header_id = x_interface_header_id
8682: AND phi.interface_header_id = pli.interface_header_id
8683: AND pli.requisition_line_id is null
8684: AND plt.line_type_id = pli.line_type_id;

Line 9241: po_line_types plt,

9237: prl.vmi_flag -- VMI FPH
9238: FROM po_lines_interface pli,
9239: po_headers_interface phi,
9240: po_requisition_lines_all prl, --
9241: po_line_types plt,
9242: po_lines_all pol --
9243: WHERE pli.interface_line_id = pli2.interface_line_id
9244: AND pli.interface_header_id = phi.interface_header_id
9245: AND phi.interface_header_id = x_interface_header_id

Line 9436: po_line_types plt

9432: --
9433: FROM po_lines_interface pli,
9434: po_headers_interface phi,
9435: po_requisition_lines_all prl, --
9436: po_line_types plt
9437: WHERE pli.interface_line_id = pli2.interface_line_id
9438: AND pli.interface_header_id = phi.interface_header_id
9439: AND phi.interface_header_id = x_interface_header_id
9440: AND pli.requisition_line_id = prl.requisition_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:

Line 12186: PO_LINE_TYPES PLT --

12182: INTO x_po_shipment_num,
12183: x_line_location_to_check
12184: FROM PO_LINE_LOCATIONS_ALL PLL, --
12185: PO_LINES_ALL POL, --
12186: PO_LINE_TYPES PLT --
12187: WHERE POL.PO_LINE_ID = l_po_line_id -- bug2788115
12188: AND POL.po_line_id = PLL.po_line_id --
12189: AND POL.line_type_id = PLT.line_type_id --
12190: AND PLT.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE')--

Line 12303: po_line_types plt,

12299: FROM po_lines_interface pli,
12300: po_headers_interface phi,
12301: po_requisition_lines_all prl, --
12302: mtl_system_items msi,
12303: po_line_types plt,
12304: po_vendors pov,
12305: po_system_parameters_all psp, --
12306: financials_system_params_all fsp --
12307: WHERE pli.item_id = msi.inventory_item_id(+)

Line 12366: PO_LINE_TYPES PLT ,

12362: FROM PO_LINES_INTERFACE PLI,
12363: PO_REQUISITION_LINES_ALL PRL, --
12364: --bug 1942696 hr_location changes to reflect the new view
12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,
12367: PO_SYSTEM_PARAMETERS_ALL PSP , --
12368: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12369: PO_VENDORS POV,
12370: PO_HEADERS_INTERFACE PHI

Line 12487: PO_LINE_TYPES PLT ,

12483: INTO x_po_shipment_num
12484: FROM PO_LINES_INTERFACE PLI,
12485: PO_REQUISITION_LINES_ALL PRL, --
12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --
12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12490: PO_VENDORS POV,
12491: PO_HEADERS_INTERFACE PHI

Line 12615: PO_LINE_TYPES PLT ,

12611: FROM PO_LINES_INTERFACE PLI,
12612: PO_REQUISITION_LINES_ALL PRL, --
12613: --bug 1942696 hr_location changes to reflect the new view
12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,
12616: PO_SYSTEM_PARAMETERS_ALL PSP , --
12617: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12618: PO_VENDORS POV,
12619: PO_HEADERS_INTERFACE PHI