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

3079: x_result varchar2(7);
3080: update_req_pool_fail exception;
3081: x_hazard_class_id number:=null;
3082: x_un_number_id number:=null;
3083: x_unit_of_measure po_line_types.unit_of_measure%type:=null;
3084: --The following flag indicates whether copying the attachments from (all)the
3085: --sourcing entities need to be suppressed due to the grouping of lines.
3086: x_attch_suppress_flag varchar2(1) :='N';
3087: --

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

3239: SELECT order_type_lookup_code
3240: , purchase_basis --
3241: INTO x_order_type_lookup_code
3242: , l_purchase_basis --
3243: FROM po_line_types
3244: WHERE line_type_id = interface.line_type_id;
3245: END IF; -- Bug 586033, lpo, 11/25/97
3246:
3247: l_progress := '020';

Line 3683: FROM po_line_types_v

3679: SELECT nvl(item.receive_close_tolerance,receipt_close),
3680: nvl(item.receipt_required_flag,receiving_flag)
3681: INTO item.receive_close_tolerance,
3682: item.receipt_required_flag
3683: FROM po_line_types_v
3684: WHERE line_type_id = interface.line_type_id;
3685: exception
3686: when no_data_found then
3687: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 4019: from po_line_types

4015: begin
4016: l_progress:='280';
4017: select unit_of_measure
4018: into x_unit_of_measure
4019: from po_line_types
4020: where line_type_id= interface.line_type_id;
4021: exception
4022: when others then
4023: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >

Line 4201: PO_LINE_TYPES_SV.get_line_type_def(

4197: l_progress := '380';
4198: --
4199: -- Retrieve the values for order_type_lookup_code, purchase_basis
4200: -- and matching_basis
4201: PO_LINE_TYPES_SV.get_line_type_def(
4202: interface.line_type_id,
4203: l_order_type_lookup_code,
4204: l_purchase_basis1,
4205: l_matching_basis,

Line 4766: FROM po_line_types_v

4762: SELECT nvl(item.receive_close_tolerance,receipt_close),
4763: nvl(item.receipt_required_flag,receiving_flag)
4764: INTO item.receive_close_tolerance,
4765: item.receipt_required_flag
4766: FROM po_line_types_v
4767: WHERE line_type_id = interface.line_type_id;
4768: exception
4769: when no_data_found then
4770: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

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

5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5762: --
5763:
5764: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --
5765: l_inspection_required_flag VARCHAR2(1); --10403047
5766: l_receipt_required_flag VARCHAR2(1); --10403047
5767:
5768: BEGIN

Line 5798: FROM po_line_types plt

5794: -- : Also get matching basis
5795:
5796: SELECT plt.order_type_lookup_code, plt.matching_basis
5797: INTO x_order_type_lookup_code, l_matching_basis
5798: FROM po_line_types plt
5799: WHERE plt.line_type_id = interface.line_type_id;
5800:
5801: --
5802: --

Line 7146: FROM po_line_types

7142:
7143: l_progress := '030';
7144: SELECT order_type_lookup_code
7145: INTO x_order_type_lookup_code
7146: FROM po_line_types
7147: WHERE line_type_id = interface.line_type_id;
7148:
7149: l_progress := '040';
7150: SELECT set_of_books_id

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

9294: phi.document_subtype,
9295: pli.unit_price --
9296: FROM po_lines_interface pli,
9297: po_headers_interface phi,
9298: po_line_types plt
9299: WHERE phi.interface_header_id = x_interface_header_id
9300: AND phi.interface_header_id = pli.interface_header_id
9301: AND pli.requisition_line_id is null
9302: AND plt.line_type_id = pli.line_type_id;

Line 9860: po_line_types plt,

9856: prl.vmi_flag -- VMI FPH
9857: FROM po_lines_interface pli,
9858: po_headers_interface phi,
9859: po_requisition_lines_all prl, --
9860: po_line_types plt,
9861: po_lines_all pol --
9862: WHERE pli.interface_line_id = pli2.interface_line_id
9863: AND pli.interface_header_id = phi.interface_header_id
9864: AND phi.interface_header_id = x_interface_header_id

Line 10064: po_line_types plt

10060: ,pol.supplier_part_auxid --13876074
10061: FROM po_lines_interface pli,
10062: po_headers_interface phi,
10063: po_requisition_lines_all prl, --
10064: po_line_types plt
10065: ,po_lines_all pol --13876074
10066: WHERE pli.interface_line_id = pli2.interface_line_id
10067: AND pli.interface_header_id = phi.interface_header_id
10068: AND phi.interface_header_id = x_interface_header_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:

Line 12908: PO_LINE_TYPES PLT --

12904: INTO x_po_shipment_num,
12905: x_line_location_to_check
12906: FROM PO_LINE_LOCATIONS_ALL PLL, --
12907: PO_LINES_ALL POL, --
12908: PO_LINE_TYPES PLT --
12909: WHERE POL.PO_LINE_ID = l_po_line_id -- bug2788115
12910: AND POL.po_line_id = PLL.po_line_id --
12911: AND POL.line_type_id = PLT.line_type_id --
12912: AND PLT.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE')--

Line 13025: po_line_types plt,

13021: FROM po_lines_interface pli,
13022: po_headers_interface phi,
13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,
13027: po_system_parameters_all psp, --
13028: financials_system_params_all fsp --
13029: WHERE pli.item_id = msi.inventory_item_id(+)

Line 13088: PO_LINE_TYPES PLT ,

13084: FROM PO_LINES_INTERFACE PLI,
13085: PO_REQUISITION_LINES_ALL PRL, --
13086: --bug 1942696 hr_location changes to reflect the new view
13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --
13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13091: PO_VENDORS POV,
13092: PO_HEADERS_INTERFACE PHI

Line 13209: PO_LINE_TYPES PLT ,

13205: INTO x_po_shipment_num
13206: FROM PO_LINES_INTERFACE PLI,
13207: PO_REQUISITION_LINES_ALL PRL, --
13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13212: PO_VENDORS POV,
13213: PO_HEADERS_INTERFACE PHI

Line 13337: PO_LINE_TYPES PLT ,

13333: FROM PO_LINES_INTERFACE PLI,
13334: PO_REQUISITION_LINES_ALL PRL, --
13335: --bug 1942696 hr_location changes to reflect the new view
13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --
13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13340: PO_VENDORS POV,
13341: PO_HEADERS_INTERFACE PHI