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 1477: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;

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

Line 1478: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;

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

Line 1536: po_headers_all poh, --CTO changes FPH

1532: -- Bug 3361128: also select the UOM on the doc
1533: pol.unit_meas_lookup_code
1534: FROM po_asl_documents pad,
1535: po_approved_supplier_list pasl,
1536: po_headers_all poh, --CTO changes FPH
1537: po_lines_all pol --CTO changes FPH
1538: WHERE pasl.asl_id = x_local_asl_id
1539: AND pad.asl_id = pasl.asl_id
1540: AND pad.using_organization_id = l_using_organization_id --

Line 1729: po_headers_all poh --CTO changes FPH

1725: poh.org_id,
1726: NULL unit_meas_lookup_code
1727: FROM po_asl_documents pad,
1728: po_approved_supplier_list pasl,
1729: po_headers_all poh --CTO changes FPH
1730: WHERE pasl.asl_id = x_local_asl_id
1731: AND pad.asl_id = pasl.asl_id
1732: AND pad.using_organization_id = l_using_organization_id --
1733: AND pad.document_header_id = poh.po_header_id

Line 2478: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

2474: x_auto_source_doc VARCHAR2(1);
2475: x_asl_purchasing_uom VARCHAR2(25);
2476: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
2477: x_return_status VARCHAR2(1); --
2478: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
2479: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
2480: l_using_organization_id NUMBER;
2481: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_latest_document';
2482: l_noncat_item BOOLEAN := FALSE; /* Bug#4263138 */

Line 2479: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;

2475: x_asl_purchasing_uom VARCHAR2(25);
2476: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
2477: x_return_status VARCHAR2(1); --
2478: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
2479: l_document_org_id PO_HEADERS_ALL.org_id%TYPE;
2480: l_using_organization_id NUMBER;
2481: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_latest_document';
2482: l_noncat_item BOOLEAN := FALSE; /* Bug#4263138 */
2483:

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

2529: decode(pol.unit_meas_lookup_code, p_purchasing_uom, 1,2) MatchUom,
2530: NVL (poh.global_agreement_flag, 'N') global_flag,
2531: poh.creation_date creation_date,
2532: pol.expiration_date expiration_date --Bug14145177
2533: FROM po_headers_all poh, --CTO changes FPH
2534: po_lines_all pol --CTO changes FPH
2535: WHERE pol.po_header_id = poh.po_header_id -- Bug5081434 No Outer Join
2536: AND (x_document_line_id IS NULL OR x_document_line_id <> pol.po_line_id) -- Bug # 7454607 --bug10216412
2537: AND ( x_destination_doc_type = 'REQ'

Line 2709: FROM po_headers_all poh

2705: 2 MatchUom,
2706: NVL (poh.global_agreement_flag, 'N') global_flag,
2707: poh.creation_date creation_date,
2708: NULL expiration_date --Bug14145177
2709: FROM po_headers_all poh
2710: WHERE ( x_destination_doc_type = 'REQ'
2711: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2712: OR x_destination_doc_type = 'STANDARD PO' --ER 12625661
2713: OR x_destination_doc_type IS NULL

Line 2834: FROM po_headers_all poh --CTO changes FPH

2830: x_vendor_product_num,
2831: poh.global_agreement_flag,
2832: poh.org_id,
2833: NULL unit_meas_lookup_code
2834: FROM po_headers_all poh --CTO changes FPH
2835: WHERE
2836: ( x_destination_doc_type = 'REQ'
2837: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2838: OR x_destination_doc_type = 'STANDARD PO' --ER 12625661

Line 3454: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;

3450: l_is_org_valid BOOLEAN := FALSE;
3451: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3452: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3453: l_vendor_contact_name VARCHAR2(240); --
3454: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3455: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3456: l_progress VARCHAR2(3) := '000';
3457: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_site_id_if_item_on_doc_ok';
3458: BEGIN

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

3451: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3452: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3453: l_vendor_contact_name VARCHAR2(240); --
3454: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3455: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3456: l_progress VARCHAR2(3) := '000';
3457: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_site_id_if_item_on_doc_ok';
3458: BEGIN
3459:

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

3858: IS
3859: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
3860: --SQL WHY: This information will be used to identify the document in ASL.
3861: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
3862: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
3863: -- po_header_id, po_lines_all using po_line_id
3864: SELECT pasl.asl_id, paa.using_organization_id,
3865: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3866: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,

Line 3872: po_headers_all poh,

3868: FROM po_approved_supplier_lis_val_v pasl,
3869: po_asl_attributes paa,
3870: po_asl_status_rules_v pasr,
3871: po_asl_documents pad,
3872: po_headers_all poh,
3873: po_lines_all pol
3874: WHERE pasl.item_id = p_item_id --
3875: AND pasl.vendor_id = p_vendor_id
3876: AND pasl.using_organization_id in (-1, p_using_organization_id) --

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

4231: IS
4232: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
4233: --SQL WHY: This information will be used to identify the document in ASL.
4234: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
4235: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
4236: -- po_header_id, po_lines_all using po_line_id
4237: SELECT pasl.asl_id, paa.using_organization_id,
4238: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4239: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,

Line 4245: po_headers_all poh,

4241: FROM po_approved_supplier_lis_val_v pasl,
4242: po_asl_attributes paa,
4243: po_asl_status_rules_v pasr,
4244: po_asl_documents pad,
4245: po_headers_all poh,
4246: po_lines_all pol
4247: WHERE pasl.category_id = p_category_id --
4248: AND pasl.vendor_id = p_vendor_id
4249: AND pasl.using_organization_id in (-1, p_using_organization_id) --

Line 5326: po_Headers_All h

5322: WHERE po_Requisitions_InterFace.AutoSource_Doc_Header_Id IS NOT NULL
5323: AND po_Requisitions_Interface.request_id = x_request_id
5324: AND EXISTS (SELECT 'BPA Encumbered'
5325: FROM po_Distributions_All d,
5326: po_Headers_All h
5327: WHERE h.po_Header_Id = po_Requisitions_InterFace.AutoSource_Doc_Header_Id
5328: AND h.po_Header_Id = d.po_Header_Id
5329: AND h.Type_LookUp_Code = 'BLANKET'
5330: AND d.Line_Location_Id IS NULL

Line 5674: from po_headers_all poh

5670: --
5671: IF x_document_header_id is NOT NULL THEN --
5672: select poh.type_lookup_code
5673: into x_type_lookup_code
5674: from po_headers_all poh
5675: where poh.po_header_id = x_document_header_id;
5676:
5677: /* If it is not blanket then return null */
5678: if (x_type_lookup_code <> 'BLANKET') THEN

Line 5973: po_headers_all poh,

5969: nvl(pol.allow_price_override_flag,'N'),
5970: pol.not_to_exceed_price,
5971: pol.unit_meas_lookup_code
5972: FROM po_asl_documents pad,
5973: po_headers_all poh,
5974: po_lines_all pol
5975: WHERE pad.asl_id = l_asl_id
5976: AND pad.document_header_id = poh.po_header_id
5977: --

Line 6049: FROM po_headers_all poh,

6045: poh.type_lookup_code,
6046: nvl(pol.allow_price_override_flag,'N'),
6047: pol.not_to_exceed_price,
6048: pol.unit_meas_lookup_code
6049: FROM po_headers_all poh,
6050: po_lines_all pol
6051: WHERE poh.vendor_id = l_vendor_id
6052: AND poh.type_lookup_code IN ('BLANKET','CONTRACT')
6053: AND ( ( poh.type_lookup_code = 'CONTRACT'

Line 6126: l_rate_type po_headers_all.rate_type%TYPE;

6122: poh.creation_date DESC;
6123: --
6124:
6125: l_discount po_line_locations_all.price_discount%TYPE;
6126: l_rate_type po_headers_all.rate_type%TYPE;
6127: l_rate_date po_headers_all.rate_date%TYPE;
6128: l_rate po_headers_all.rate%TYPE;
6129: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6130: l_base_price po_lines_all.unit_price%TYPE;

Line 6127: l_rate_date po_headers_all.rate_date%TYPE;

6123: --
6124:
6125: l_discount po_line_locations_all.price_discount%TYPE;
6126: l_rate_type po_headers_all.rate_type%TYPE;
6127: l_rate_date po_headers_all.rate_date%TYPE;
6128: l_rate po_headers_all.rate%TYPE;
6129: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6130: l_base_price po_lines_all.unit_price%TYPE;
6131: l_currency_price po_lines_all.unit_price%TYPE;

Line 6128: l_rate po_headers_all.rate%TYPE;

6124:
6125: l_discount po_line_locations_all.price_discount%TYPE;
6126: l_rate_type po_headers_all.rate_type%TYPE;
6127: l_rate_date po_headers_all.rate_date%TYPE;
6128: l_rate po_headers_all.rate%TYPE;
6129: l_base_unit_price po_lines_all.base_unit_price%TYPE; --
6130: l_base_price po_lines_all.unit_price%TYPE;
6131: l_currency_price po_lines_all.unit_price%TYPE;
6132: l_currency_amount po_lines_all.unit_price%TYPE;

Line 6134: l_currency_code po_headers_all.currency_code%TYPE;

6130: l_base_price po_lines_all.unit_price%TYPE;
6131: l_currency_price po_lines_all.unit_price%TYPE;
6132: l_currency_amount po_lines_all.unit_price%TYPE;
6133: l_base_amount po_lines_all.unit_price%TYPE;
6134: l_currency_code po_headers_all.currency_code%TYPE;
6135: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6136: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6138: l_entity_type po_price_differentials.entity_type%TYPE;

Line 6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;

6135: l_price_break_id po_line_locations_all.line_location_id%TYPE;
6136: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6138: l_entity_type po_price_differentials.entity_type%TYPE;
6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6140: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6141: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6142: l_src_doc_line_num po_lines_all.line_num%TYPE;
6143: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;

Line 6140: l_src_doc_header_id po_headers_all.po_header_id%TYPE;

6136: l_price_diff_src_id po_price_differentials.entity_id%TYPE;
6137: l_using_organization_id po_approved_supplier_list.using_organization_id%TYPE;
6138: l_entity_type po_price_differentials.entity_type%TYPE;
6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6140: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6141: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6142: l_src_doc_line_num po_lines_all.line_num%TYPE;
6143: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;
6144: l_price_override_flag po_lines_all.allow_price_override_flag%TYPE;

Line 6143: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;

6139: l_vendor_contact_id po_headers_all.vendor_contact_id%TYPE;
6140: l_src_doc_header_id po_headers_all.po_header_id%TYPE;
6141: l_src_doc_line_id po_lines_all.po_line_id%TYPE;
6142: l_src_doc_line_num po_lines_all.line_num%TYPE;
6143: l_src_doc_type_code po_headers_all.type_lookup_code%TYPE;
6144: l_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
6145: l_not_to_exceed_price po_lines_all.not_to_exceed_price%TYPE;
6146: l_unit_of_measure po_lines_all.unit_meas_lookup_code%TYPE;
6147: l_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 6821: l_rate_type po_headers_all.rate_type%TYPE;

6817: , x_rate_date OUT NOCOPY DATE
6818: , x_rate OUT NOCOPY NUMBER )
6819: IS
6820:
6821: l_rate_type po_headers_all.rate_type%TYPE;
6822: l_rate_date po_headers_all.rate_date%TYPE;
6823: l_rate po_headers_all.rate%TYPE;
6824: l_base_amount po_lines_all.amount%TYPE;
6825: l_currency_amount po_lines_all.amount%TYPE;

Line 6822: l_rate_date po_headers_all.rate_date%TYPE;

6818: , x_rate OUT NOCOPY NUMBER )
6819: IS
6820:
6821: l_rate_type po_headers_all.rate_type%TYPE;
6822: l_rate_date po_headers_all.rate_date%TYPE;
6823: l_rate po_headers_all.rate%TYPE;
6824: l_base_amount po_lines_all.amount%TYPE;
6825: l_currency_amount po_lines_all.amount%TYPE;
6826: l_currency_code po_headers_all.currency_code%TYPE;

Line 6823: l_rate po_headers_all.rate%TYPE;

6819: IS
6820:
6821: l_rate_type po_headers_all.rate_type%TYPE;
6822: l_rate_date po_headers_all.rate_date%TYPE;
6823: l_rate po_headers_all.rate%TYPE;
6824: l_base_amount po_lines_all.amount%TYPE;
6825: l_currency_amount po_lines_all.amount%TYPE;
6826: l_currency_code po_headers_all.currency_code%TYPE;
6827: l_base_curr_ext_precision number;

Line 6826: l_currency_code po_headers_all.currency_code%TYPE;

6822: l_rate_date po_headers_all.rate_date%TYPE;
6823: l_rate po_headers_all.rate%TYPE;
6824: l_base_amount po_lines_all.amount%TYPE;
6825: l_currency_amount po_lines_all.amount%TYPE;
6826: l_currency_code po_headers_all.currency_code%TYPE;
6827: l_base_curr_ext_precision number;
6828: l_sob_id number;
6829:
6830: BEGIN

Line 6838: FROM po_headers_all poh,

6834: SELECT poh.currency_code ,
6835: pol.amount
6836: INTO l_currency_code ,
6837: l_currency_amount
6838: FROM po_headers_all poh,
6839: po_lines_all pol
6840: WHERE poh.po_header_id = pol.po_header_id
6841: AND poh.po_header_id = p_source_document_header_id
6842: AND pol.po_line_id = p_source_document_line_id;