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_HEADERS_INTERFACE

Line 312: FROM po_headers_interface phi,

308: , pli.ip_category_id ip_category_id
309: , pli.supplier_part_auxid supplier_part_auxid
310: , pli.catalog_name catalog_name
311: --
312: FROM po_headers_interface phi,
313: po_lines_interface pli,
314: po_distributions_interface pdi
315: WHERE phi.interface_header_id = pli.interface_header_id
316: AND pli.interface_line_id = pdi.interface_line_id

Line 344: g_mode po_headers_interface.action%type := null;

340: g_sourcing_errorcode number;
341: g_interface_source_code varchar2(25);
342: --
343:
344: g_mode po_headers_interface.action%type := null;
345: g_group_code po_headers_interface.group_code%type := null;
346: g_document_subtype po_headers_interface.document_subtype%type := null;
347: g_po_release_id number := null;
348: g_document_type varchar2(25) := null;

Line 345: g_group_code po_headers_interface.group_code%type := null;

341: g_interface_source_code varchar2(25);
342: --
343:
344: g_mode po_headers_interface.action%type := null;
345: g_group_code po_headers_interface.group_code%type := null;
346: g_document_subtype po_headers_interface.document_subtype%type := null;
347: g_po_release_id number := null;
348: g_document_type varchar2(25) := null;
349: g_number_records_processed number;

Line 346: g_document_subtype po_headers_interface.document_subtype%type := null;

342: --
343:
344: g_mode po_headers_interface.action%type := null;
345: g_group_code po_headers_interface.group_code%type := null;
346: g_document_subtype po_headers_interface.document_subtype%type := null;
347: g_po_release_id number := null;
348: g_document_type varchar2(25) := null;
349: g_number_records_processed number;
350: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --

Line 512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

508:
509: --
510:
511: FUNCTION validate_interface_records (
512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
513: ) RETURN BOOLEAN;
514:
515: FUNCTION validate_config_id (
516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

Line 516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

512: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
513: ) RETURN BOOLEAN;
514:
515: FUNCTION validate_config_id (
516: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
517: ) RETURN BOOLEAN;
518:
519: --
520:

Line 856: FROM po_headers_interface

852:
853: /* For now a batch has only one header, so get the document header id */
854: SELECT min(interface_header_id)
855: INTO x_interface_header_id
856: FROM po_headers_interface
857: WHERE batch_id = p_batch_id; --
858:
859: l_progress:='040';
860: --

Line 866: FROM po_headers_interface

862: --
863: --Modified the select statement to select document_subtype as well.
864: SELECT document_type_code,document_subtype,nvl(interface_source_code,'NOCODE')
865: INTO g_document_type,g_document_subtype,g_interface_source_code
866: FROM po_headers_interface
867: WHERE interface_header_id = x_interface_header_id;
868:
869: -- Populate global variable to indicate whether
870: -- tax is calculated for this document type

Line 1298: FROM po_headers_interface phi

1294:
1295: --
1296: SELECT phi.style_id
1297: INTO l_style_id
1298: FROM po_headers_interface phi
1299: WHERE phi.interface_header_id = x_interface_header_id;
1300:
1301: IF (l_style_id IS NOT NULL) THEN
1302: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_style(

Line 1765: --For more comments please refer to update po_headers_interface phi

1761: end if;
1762:
1763: --
1764: --The following insert is modified to take care of defaulting for sourcing
1765: --For more comments please refer to update po_headers_interface phi
1766: --in setup_interface_tables procedure.
1767: /* Bug 2816396
1768: Use the interface table value for pay_on_code when inserting into po_headers.pay_on_code
1769: */

Line 7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%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;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;

Line 7950: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%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;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;

Line 7951: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%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;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
7955: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;

Line 7952: l_req_header_rate PO_HEADERS_INTERFACE.rate%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;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
7955: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
7956: -- Bug 3463242 END

Line 7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%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;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
7955: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
7956: -- Bug 3463242 END
7957:
7958: l_item_in_linv_pou VARCHAR2(1):= 'Y'; -- Bug 3433867

Line 8009: PO_HEADERS_INTERFACE phi,

8005: pdi.rate
8006: -- Bug 3463242 END
8007: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8008: PO_LINES_INTERFACE pli,
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

Line 8648: po_headers_interface phi,

8644: phi.vendor_id,
8645: phi.vendor_site_id,
8646: pdi.destination_organization_id
8647: from po_lines_interface pli,
8648: po_headers_interface phi,
8649: po_distributions_interface pdi
8650: where phi.interface_header_id = x_interface_header_id
8651: and phi.interface_header_id = pli.interface_header_id
8652: and pdi.interface_distribution_id =

Line 8679: po_headers_interface phi,

8675: phi.rate_date,
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

Line 8716: UPDATE po_headers_interface

8712: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
8713: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
8714: END IF;
8715:
8716: UPDATE po_headers_interface
8717: SET process_code = 'IN PROCESS'
8718: WHERE interface_header_id = x_interface_header_id;
8719:
8720: l_progress := '010';

Line 8738: FROM po_headers_interface

8734: min(document_num)
8735: INTO g_mode,
8736: g_group_code,
8737: x_old_document_num
8738: FROM po_headers_interface
8739: WHERE interface_header_id = x_interface_header_id;
8740:
8741: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
8742: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 8758: UPDATE po_headers_interface phi

8754: */
8755:
8756: IF (g_document_type = 'RFQ') THEN
8757: l_progress:='030';
8758: UPDATE po_headers_interface phi
8759: SET po_header_id =
8760: (SELECT ph.po_header_id
8761: FROM po_headers_all ph --
8762: WHERE 'RFQ' = ph.type_lookup_code

Line 8769: UPDATE po_headers_interface phi

8765: WHERE interface_header_id = x_interface_header_id;
8766:
8767: ELSE
8768: l_progress:='040';
8769: UPDATE po_headers_interface phi
8770: SET po_header_id =
8771: (SELECT ph.po_header_id
8772: FROM po_headers_all ph --
8773: WHERE decode(phi.document_subtype,

Line 8799: UPDATE po_headers_interface phi

8795: /* Bug 482648 add currecny_code */
8796:
8797: /* Also get the pay_on_code from the document */
8798:
8799: UPDATE po_headers_interface phi
8800: SET (
8801: rate,
8802: rate_type_code,
8803: rate_date,

Line 8856: ** should already be loaded into the po_headers_interface table.

8852:
8853: /* If we are using automatic numbering, get segment1
8854: ** from the po_unique_identifier_control table.
8855: ** If we are using manual numbering, segment1
8856: ** should already be loaded into the po_headers_interface table.
8857: ** The checks to verify that a manual po number is unique
8858: ** is done on the client side.
8859: */
8860: /* ecso 4/23/98 emergency requisition enhancement

Line 8864: ** and there exists a document_num on po_headers_interface

8860: /* ecso 4/23/98 emergency requisition enhancement
8861: ** For emergency requisitions, there is a reserved po num
8862: ** even though the document has not been created.
8863: ** Add the case where the document is NEW
8864: ** and there exists a document_num on po_headers_interface
8865: */
8866: --
8867: --modified the if condition to include PA
8868: IF (params.po_num_code='AUTOMATIC') AND

Line 8936: po_headers_interface phi

8932: INTO x_po_header_id,
8933: x_pay_on_code,
8934: l_shipping_control --
8935: FROM po_headers_all ph, --
8936: po_headers_interface phi
8937: WHERE phi.interface_header_id = x_interface_header_id
8938: AND ph.segment1 = phi.document_num
8939: AND ph.type_lookup_code='BLANKET'
8940: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99); --

Line 8955: po_headers_interface phi

8951:
8952: SELECT min(interface_line_id)
8953: INTO x_min_interface_line_id
8954: FROM po_lines_interface pli,
8955: po_headers_interface phi
8956: WHERE phi.interface_header_id=pli.interface_header_id
8957: AND phi.interface_header_id = x_interface_header_id;
8958:
8959: l_progress:='100';

Line 8965: --interface tables. But po_headers_interface table would contain values

8961: --modify the following update to default the values for the blanket also.
8962: --track 'PA' for the changes. Also please note that we have added deocode
8963: --for all the terms and conditions.Existing autocreate would not values
8964: --for different terms n condition columns and shipto billto columns in the
8965: --interface tables. But po_headers_interface table would contain values
8966: --for these columns when called from sourcing. So we are not defaulting
8967: --these values from params here but would do this in create_po procedure
8968: --in the order of interface,vendor,params.
8969: /* Bug 2816396

Line 8978: UPDATE po_headers_interface phi

8974: p_token => l_progress,
8975: p_message => 'Sourcing to FPH-6 starts');
8976: END IF;
8977:
8978: UPDATE po_headers_interface phi
8979: SET (po_header_id,
8980: last_update_date,
8981: last_updated_by,
8982: document_num,

Line 9074: FROM po_headers_interface phi2,

9070: 'PA',nvl(phi.min_release_amount,params.min_rel_amount),
9071: null),
9072: phi.document_subtype,
9073: l_shipping_control --
9074: FROM po_headers_interface phi2,
9075: po_lines_interface pli
9076: WHERE phi2.interface_header_id = phi.interface_header_id
9077: AND pli.interface_header_id=phi2.interface_header_id
9078: AND pli.interface_line_id = x_min_interface_line_id)

Line 9095: from po_headers_interface

9091: IF (g_document_subtype = 'RELEASE') THEN
9092:
9093: select po_header_id
9094: into x_po_header_id
9095: from po_headers_interface
9096: where interface_header_id = x_interface_header_id;
9097:
9098: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9099: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 9239: po_headers_interface phi,

9235: -- end of 1548597
9236: prl.drop_ship_flag, --
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

Line 9277: po_headers_interface phi

9273: x_po_header_id,
9274: nvl(pli.negotiated_by_preparer_flag,'N'),
9275: nvl(pli.firm_flag,'N')
9276: FROM po_lines_interface pli,
9277: po_headers_interface phi
9278: WHERE pli.interface_line_id = pli2.interface_line_id
9279: AND pli.interface_header_id = phi.interface_header_id
9280: AND phi.interface_header_id = x_interface_header_id);
9281:

Line 9434: po_headers_interface phi,

9430: nvl(pli.contractor_first_name, prl.candidate_first_name),
9431: nvl(pli.contractor_last_name, prl.candidate_last_name)
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

Line 9582: po_headers_interface phi

9578: prd.oke_contract_deliverable_id)
9579: FROM po_requisition_lines_all prl, --
9580: po_req_distributions_all prd, --
9581: po_lines_interface pli,
9582: po_headers_interface phi
9583: WHERE prd.requisition_line_id = prl.requisition_line_id
9584: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888
9585: AND pli.interface_header_id = phi.interface_header_id
9586: AND phi.interface_header_id = x_interface_header_id;

Line 9842: DELETE po_headers_interface

9838: DELETE po_lines_interface
9839: WHERE interface_header_id = x_interface_header_id;
9840:
9841:
9842: DELETE po_headers_interface
9843: WHERE interface_header_id = x_interface_header_id;
9844:
9845: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9846: PO_DEBUG.debug_end(p_log_head => g_log_head||'wrapup');

Line 10026: FROM po_headers_interface phi

10022: INTO x_document_num,
10023: x_document_type_code,
10024: x_document_subtype,
10025: x_release_num
10026: FROM po_headers_interface phi
10027: WHERE phi.interface_header_id = x_interface_header_id;
10028:
10029: IF (g_document_type = 'RFQ') THEN
10030: x_document_subtype := 'RFQ';

Line 12118: po_headers_interface phi

12114:
12115: SELECT por.po_release_id
12116: INTO g_po_release_id
12117: FROM po_releases_all por, --
12118: po_headers_interface phi
12119: WHERE phi.interface_header_id = x_interface_header_id
12120: AND phi.release_num = por.release_num
12121: AND phi.po_header_id = por.po_header_id
12122: AND NVL(por.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 12159: FROM po_headers_interface PHI,

12155: );
12156:
12157: SELECT POL.po_line_id
12158: INTO l_po_line_id
12159: FROM po_headers_interface PHI,
12160: po_lines_all POL
12161: WHERE PHI.interface_header_id = x_interface_header_id
12162: AND PHI.po_header_id = POL.po_header_id
12163: AND POL.line_num = x_po_line_num;

Line 12300: po_headers_interface phi,

12296: 'INVENTORY', 'Y',
12297: 'SHOP FLOOR','Y')
12298: INTO x_receipt_required_flag
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,

Line 12370: PO_HEADERS_INTERFACE PHI

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
12371: WHERE PLI.LINE_NUM = x_po_line_num
12372: AND PLI.shipment_num is not null
12373: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
12374: AND NVL(fsp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 12491: PO_HEADERS_INTERFACE PHI

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
12492: WHERE PLI.LINE_NUM = x_po_line_num
12493: AND PLI.shipment_num is not null
12494: AND PLI.item_id = MSI.inventory_item_id
12495: AND MSI.organization_id=

Line 12582: PO_HEADERS_INTERFACE

12578: l_progress:='180';
12579: SELECT document_subtype
12580: into x_check_doc_sub_type
12581: from
12582: PO_HEADERS_INTERFACE
12583: WHERE
12584: INTERFACE_HEADER_ID=x_interface_header_id;
12585: exception
12586: When others then

Line 12619: PO_HEADERS_INTERFACE PHI

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
12620: WHERE PLI.LINE_NUM = x_po_line_num
12621: AND PLI.shipment_num is not null
12622: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
12623: AND NVL(fsp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 13578: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

13574: --End of Comments
13575: ----------------------------------------------------------------------------
13576:
13577: FUNCTION validate_interface_records (
13578: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
13579: ) RETURN BOOLEAN IS
13580:
13581: l_api_name CONSTANT VARCHAR2(30) := 'validate_interface_records';
13582: l_pass_validations BOOLEAN;

Line 13616: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE

13612: --End of Comments
13613: ----------------------------------------------------------------------------
13614:
13615: FUNCTION validate_config_id (
13616: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE
13617: ) RETURN BOOLEAN IS
13618:
13619: l_api_name CONSTANT VARCHAR2(30) := 'validate_config_id';
13620: l_num_config_id_lines NUMBER;

Line 13908: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

13904: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
13905: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
13906: l_display_rate NUMBER;
13907: l_progress VARCHAR2(3) := '000';
13908: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
13909: l_api_name CONSTANT VARCHAR2(30) := 'get_rate_for_req_price'; --< Bug 3210331 >
13910:
13911: BEGIN
13912: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >