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_AUTOSOURCE_SV dependencies on PO_HEADERS_ALL

Line 1473: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;

1469: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE; --
1470: x_consigned_from_supplier_flag VARCHAR2(1);
1471: x_enable_vmi_flag VARCHAR2(1);
1472: x_return_status VARCHAR2(1); --
1473: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
1474: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
1475: l_using_organization_id NUMBER;
1476: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_document_from_asl';
1477:

Line 1474: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;

1470: x_consigned_from_supplier_flag VARCHAR2(1);
1471: x_enable_vmi_flag VARCHAR2(1);
1472: x_return_status VARCHAR2(1); --
1473: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
1474: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
1475: l_using_organization_id NUMBER;
1476: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_document_from_asl';
1477:
1478: -- Bug 3361128: this parameter stores the UOM on the source doc

Line 1528: po_headers_all poh, --CTO changes FPH

1524: -- Bug 3361128: also select the UOM on the doc
1525: pol.unit_meas_lookup_code
1526: FROM po_asl_documents pad,
1527: po_approved_supplier_list pasl,
1528: po_headers_all poh, --CTO changes FPH
1529: po_lines_all pol --CTO changes FPH
1530: WHERE pasl.asl_id = x_local_asl_id
1531: AND pad.asl_id = pasl.asl_id
1532: AND pad.using_organization_id = l_using_organization_id --

Line 1716: po_headers_all poh --CTO changes FPH

1712: poh.org_id,
1713: NULL unit_meas_lookup_code
1714: FROM po_asl_documents pad,
1715: po_approved_supplier_list pasl,
1716: po_headers_all poh --CTO changes FPH
1717: WHERE pasl.asl_id = x_local_asl_id
1718: AND pad.asl_id = pasl.asl_id
1719: AND pad.using_organization_id = l_using_organization_id --
1720: AND pad.document_header_id = poh.po_header_id

Line 2465: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

2461: x_auto_source_doc VARCHAR2(1);
2462: x_asl_purchasing_uom VARCHAR2(25);
2463: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
2464: x_return_status VARCHAR2(1); --
2465: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
2466: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
2467: l_using_organization_id NUMBER;
2468: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_latest_document';
2469: l_noncat_item BOOLEAN := FALSE; /* Bug#4263138 */

Line 2466: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;

2462: x_asl_purchasing_uom VARCHAR2(25);
2463: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
2464: x_return_status VARCHAR2(1); --
2465: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
2466: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
2467: l_using_organization_id NUMBER;
2468: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_latest_document';
2469: l_noncat_item BOOLEAN := FALSE; /* Bug#4263138 */
2470:

Line 2515: FROM po_headers_all poh, --CTO changes FPH

2511: decode(poh.type_lookup_code, 'BLANKET', 1, 'QUOTATION', 2) DocTypeFetchOrder,
2512: decode(pol.unit_meas_lookup_code, p_purchasing_uom, 1,2) MatchUom,
2513: NVL (poh.global_agreement_flag, 'N') global_flag,
2514: poh.creation_date creation_date
2515: FROM po_headers_all poh, --CTO changes FPH
2516: po_lines_all pol --CTO changes FPH
2517: WHERE pol.po_header_id = poh.po_header_id -- Bug5081434 No Outer Join
2518: AND ( x_destination_doc_type = 'REQ'
2519: OR x_destination_doc_type = 'REQ_NONCATALOG' --

Line 2689: FROM po_headers_all poh

2685: 3 DocTypeFetchOrder,
2686: 2 MatchUom,
2687: NVL (poh.global_agreement_flag, 'N') global_flag,
2688: poh.creation_date creation_date
2689: FROM po_headers_all poh
2690: WHERE ( x_destination_doc_type = 'REQ'
2691: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2692: OR x_destination_doc_type IS NULL
2693: )

Line 2812: FROM po_headers_all poh --CTO changes FPH

2808: x_vendor_product_num,
2809: poh.global_agreement_flag,
2810: poh.org_id,
2811: NULL unit_meas_lookup_code
2812: FROM po_headers_all poh --CTO changes FPH
2813: WHERE
2814: ( x_destination_doc_type = 'REQ'
2815: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2816: OR x_destination_doc_type IS NULL

Line 3428: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;

3424: l_is_item_valid BOOLEAN := FALSE;
3425: l_is_org_valid BOOLEAN := FALSE;
3426: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3427: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3428: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3429: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3430: l_progress VARCHAR2(3) := '000';
3431: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_site_id_if_item_on_doc_ok';
3432: BEGIN

Line 3429: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --

3425: l_is_org_valid BOOLEAN := FALSE;
3426: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3427: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3428: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3429: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3430: l_progress VARCHAR2(3) := '000';
3431: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_site_id_if_item_on_doc_ok';
3432: BEGIN
3433:

Line 3834: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using

3830: IS
3831: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
3832: --SQL WHY: This information will be used to identify the document in ASL.
3833: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
3834: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
3835: -- po_header_id, po_lines_all using po_line_id
3836: SELECT pasl.asl_id, paa.using_organization_id,
3837: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3838: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,

Line 3844: po_headers_all poh,

3840: FROM po_approved_supplier_lis_val_v pasl,
3841: po_asl_attributes paa,
3842: po_asl_status_rules_v pasr,
3843: po_asl_documents pad,
3844: po_headers_all poh,
3845: po_lines_all pol
3846: WHERE pasl.item_id = p_item_id --
3847: AND pasl.vendor_id = p_vendor_id
3848: AND pasl.using_organization_id in (-1, p_using_organization_id) --

Line 4207: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using

4203: IS
4204: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
4205: --SQL WHY: This information will be used to identify the document in ASL.
4206: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
4207: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
4208: -- po_header_id, po_lines_all using po_line_id
4209: SELECT pasl.asl_id, paa.using_organization_id,
4210: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4211: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,

Line 4217: po_headers_all poh,

4213: FROM po_approved_supplier_lis_val_v pasl,
4214: po_asl_attributes paa,
4215: po_asl_status_rules_v pasr,
4216: po_asl_documents pad,
4217: po_headers_all poh,
4218: po_lines_all pol
4219: WHERE pasl.category_id = p_category_id --
4220: AND pasl.vendor_id = p_vendor_id
4221: AND pasl.using_organization_id in (-1, p_using_organization_id) --

Line 5249: po_Headers_All h

5245: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5246: AND po_Requisitions_Interface.request_id = x_request_id
5247: AND EXISTS (SELECT 'BPA Encumbered'
5248: FROM po_Distributions_All d,
5249: po_Headers_All h
5250: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id
5251: AND h.po_Header_Id = d.po_Header_Id
5252: AND h.Type_LookUp_Code = 'BLANKET'
5253: AND d.Line_Location_Id IS NULL

Line 5597: from po_headers_all poh

5593: --
5594: IF x_document_header_id is NOT NULL THEN --
5595: select poh.type_lookup_code
5596: into x_type_lookup_code
5597: from po_headers_all poh
5598: where poh.po_header_id = x_document_header_id;
5599:
5600: /* If it is not blanket then return null */
5601: if (x_type_lookup_code <> 'BLANKET') THEN

Line 5896: po_headers_all poh,

5892: nvl(pol.allow_price_override_flag,'N'),
5893: pol.not_to_exceed_price,
5894: pol.unit_meas_lookup_code
5895: FROM po_asl_documents pad,
5896: po_headers_all poh,
5897: po_lines_all pol
5898: WHERE pad.asl_id = l_asl_id
5899: AND pad.document_header_id = poh.po_header_id
5900: --

Line 5972: FROM po_headers_all poh,

5968: poh.type_lookup_code,
5969: nvl(pol.allow_price_override_flag,'N'),
5970: pol.not_to_exceed_price,
5971: pol.unit_meas_lookup_code
5972: FROM po_headers_all poh,
5973: po_lines_all pol
5974: WHERE poh.vendor_id = l_vendor_id
5975: AND poh.type_lookup_code IN ('BLANKET','CONTRACT')
5976: AND ( ( poh.type_lookup_code = 'CONTRACT'

Line 6049: l_rate_type po_headers_all.rate_type%TYPE;

6045: poh.creation_date DESC;
6046: --
6047:
6048: l_discount po_line_locations_all.price_discount%TYPE;
6049: l_rate_type po_headers_all.rate_type%TYPE;
6050: l_rate_date po_headers_all.rate_date%TYPE;
6051: l_rate po_headers_all.rate%TYPE;
6052: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6053: l_base_price po_lines_all.unit_price%TYPE;

Line 6050: l_rate_date po_headers_all.rate_date%TYPE;

6046: --
6047:
6048: l_discount po_line_locations_all.price_discount%TYPE;
6049: l_rate_type po_headers_all.rate_type%TYPE;
6050: l_rate_date po_headers_all.rate_date%TYPE;
6051: l_rate po_headers_all.rate%TYPE;
6052: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6053: l_base_price po_lines_all.unit_price%TYPE;
6054: l_currency_price po_lines_all.unit_price%TYPE;

Line 6051: l_rate po_headers_all.rate%TYPE;

6047:
6048: l_discount po_line_locations_all.price_discount%TYPE;
6049: l_rate_type po_headers_all.rate_type%TYPE;
6050: l_rate_date po_headers_all.rate_date%TYPE;
6051: l_rate po_headers_all.rate%TYPE;
6052: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6053: l_base_price po_lines_all.unit_price%TYPE;
6054: l_currency_price po_lines_all.unit_price%TYPE;
6055: l_currency_amount po_lines_all.unit_price%TYPE;

Line 6057: l_currency_code po_headers_all.currency_code%TYPE;

6053: l_base_price po_lines_all.unit_price%TYPE;
6054: l_currency_price po_lines_all.unit_price%TYPE;
6055: l_currency_amount po_lines_all.unit_price%TYPE;
6056: l_base_amount po_lines_all.unit_price%TYPE;
6057: l_currency_code po_headers_all.currency_code%TYPE;
6058: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6059: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6060: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6061: l_entity_type po_price_differentials.entity_type%TYPE;

Line 6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;

6058: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6059: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6060: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6061: l_entity_type po_price_differentials.entity_type%TYPE;
6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6063: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6064: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6065: l_src_doc_line_num po_lines_all.line_num%TYPE;
6066: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;

Line 6063: l_src_doc_header_id po_headers_all.po_header_id%TYPE;

6059: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6060: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6061: l_entity_type po_price_differentials.entity_type%TYPE;
6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6063: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6064: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6065: l_src_doc_line_num po_lines_all.line_num%TYPE;
6066: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;
6067: l_price_override_flag po_lines_all.allow_price_override_flag%TYPE;

Line 6066: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;

6062: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6063: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6064: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6065: l_src_doc_line_num po_lines_all.line_num%TYPE;
6066: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;
6067: l_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
6068: l_not_to_exceed_price po_lines_all.not_to_exceed_price%TYPE;
6069: l_unit_of_measure po_lines_all.unit_meas_lookup_code%TYPE;
6070: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 6744: l_rate_type po_headers_all.rate_type%TYPE;

6740: , x_rate_date OUT NOCOPY DATE
6741: , x_rate OUT NOCOPY NUMBER )
6742: IS
6743:
6744: l_rate_type po_headers_all.rate_type%TYPE;
6745: l_rate_date po_headers_all.rate_date%TYPE;
6746: l_rate po_headers_all.rate%TYPE;
6747: l_base_amount po_lines_all.amount%TYPE;
6748: l_currency_amount po_lines_all.amount%TYPE;

Line 6745: l_rate_date po_headers_all.rate_date%TYPE;

6741: , x_rate OUT NOCOPY NUMBER )
6742: IS
6743:
6744: l_rate_type po_headers_all.rate_type%TYPE;
6745: l_rate_date po_headers_all.rate_date%TYPE;
6746: l_rate po_headers_all.rate%TYPE;
6747: l_base_amount po_lines_all.amount%TYPE;
6748: l_currency_amount po_lines_all.amount%TYPE;
6749: l_currency_code po_headers_all.currency_code%TYPE;

Line 6746: l_rate po_headers_all.rate%TYPE;

6742: IS
6743:
6744: l_rate_type po_headers_all.rate_type%TYPE;
6745: l_rate_date po_headers_all.rate_date%TYPE;
6746: l_rate po_headers_all.rate%TYPE;
6747: l_base_amount po_lines_all.amount%TYPE;
6748: l_currency_amount po_lines_all.amount%TYPE;
6749: l_currency_code po_headers_all.currency_code%TYPE;
6750: l_base_curr_ext_precision number;

Line 6749: l_currency_code po_headers_all.currency_code%TYPE;

6745: l_rate_date po_headers_all.rate_date%TYPE;
6746: l_rate po_headers_all.rate%TYPE;
6747: l_base_amount po_lines_all.amount%TYPE;
6748: l_currency_amount po_lines_all.amount%TYPE;
6749: l_currency_code po_headers_all.currency_code%TYPE;
6750: l_base_curr_ext_precision number;
6751: l_sob_id number;
6752:
6753: BEGIN

Line 6761: FROM po_headers_all poh,

6757: SELECT poh.currency_code ,
6758: pol.amount
6759: INTO l_currency_code ,
6760: l_currency_amount
6761: FROM po_headers_all poh,
6762: po_lines_all pol
6763: WHERE poh.po_header_id = pol.po_header_id
6764: AND poh.po_header_id = p_source_document_header_id
6765: AND pol.po_line_id = p_source_document_line_id;