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_CHANGEORDERWF_PVT dependencies on STANDARD

Line 779: if(l_type_lookup_code = 'STANDARD') then

775: from po_headers_all
776: where po_header_id = l_can_hdr_id;
777: if(l_can_rel_id is null) then
778: l_can_doc_type := 'PO';
779: if(l_type_lookup_code = 'STANDARD') then
780: l_can_doc_subtype := 'STANDARD';
781: elsif(l_type_lookup_code = 'PLANNED') then
782: l_can_doc_subtype := 'PLANNED';
783: elsif(l_type_lookup_code = 'BLANKET') then

Line 780: l_can_doc_subtype := 'STANDARD';

776: where po_header_id = l_can_hdr_id;
777: if(l_can_rel_id is null) then
778: l_can_doc_type := 'PO';
779: if(l_type_lookup_code = 'STANDARD') then
780: l_can_doc_subtype := 'STANDARD';
781: elsif(l_type_lookup_code = 'PLANNED') then
782: l_can_doc_subtype := 'PLANNED';
783: elsif(l_type_lookup_code = 'BLANKET') then
784: l_can_doc_type := 'PA';

Line 846: if(l_type_lookup_code = 'STANDARD') then

842: from po_headers_all
843: where po_header_id = l_can_hdr_id;
844: if(l_can_rel_id is null) then
845: l_can_doc_type := 'PO';
846: if(l_type_lookup_code = 'STANDARD') then
847: l_can_doc_subtype := 'STANDARD';
848: elsif(l_type_lookup_code = 'PLANNED') then
849: l_can_doc_subtype := 'PLANNED';
850: elsif(l_type_lookup_code = 'BLANKET') then

Line 847: l_can_doc_subtype := 'STANDARD';

843: where po_header_id = l_can_hdr_id;
844: if(l_can_rel_id is null) then
845: l_can_doc_type := 'PO';
846: if(l_type_lookup_code = 'STANDARD') then
847: l_can_doc_subtype := 'STANDARD';
848: elsif(l_type_lookup_code = 'PLANNED') then
849: l_can_doc_subtype := 'PLANNED';
850: elsif(l_type_lookup_code = 'BLANKET') then
851: l_can_doc_type := 'PA';

Line 1442: IF( (l_Document_Type_Code = 'RELEASE' AND l_Document_Subtype = 'BLANKET') OR (l_Document_Type_Code = 'PO' AND l_Document_Subtype = 'STANDARD') ) THEN

1438: l_faxnum := null;
1439: END IF;
1440: --
1441:
1442: IF( (l_Document_Type_Code = 'RELEASE' AND l_Document_Subtype = 'BLANKET') OR (l_Document_Type_Code = 'PO' AND l_Document_Subtype = 'STANDARD') ) THEN
1443: l_CommunicatePriceChange := 'Y';
1444: END IF;
1445: -- 1446: --so that the change request flow transmit the changes done to the PO

Line 1700: -- LINE CHANGES for Standard PO

1696: REASON,
1697: SPLIT
1698: from(
1699:
1700: -- LINE CHANGES for Standard PO
1701: select
1702: pcr.document_line_number LINE_NUM,
1703: pcr.document_shipment_number SHIPMENT_NUM,
1704: msi.concatenated_segments BUYER_PT_NUM,

Line 1740: -- SHIPMENT CHANGES for Standard PO and Releases

1736: where po_line_id = pcr.document_line_id
1737: and deliver_to_person_id = l_requestor_id)
1738: UNION ALL
1739:
1740: -- SHIPMENT CHANGES for Standard PO and Releases
1741: select
1742: pla.line_num LINE_NUM,
1743: pcr.document_shipment_number SHIPMENT_NUM,
1744: msi.concatenated_segments BUYER_PT_NUM,

Line 1914: if(l_type_lookup_code = 'STANDARD') then

1910: l_global_agreement_flag
1911: from po_headers_all
1912: where po_header_id = l_header_id;
1913:
1914: if(l_type_lookup_code = 'STANDARD') then
1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1916: elsif(l_type_lookup_code = 'PLANNED') then
1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1918: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 2532: -- LINE CHANGES for Standard PO

2528: REASON,
2529: SPLIT
2530: from(
2531:
2532: -- LINE CHANGES for Standard PO
2533: select
2534: pcr.change_request_id CHANGE_ID,
2535: pcr.document_line_number LINE_NUM,
2536: pcr.document_shipment_number SHIPMENT_NUM,

Line 2574: -- SHIPMENT CHANGES for Standard PO and Releases

2570: and msi.organization_id = mtp.organization_id
2571: and mtp.employee_id = l_planner_id
2572: UNION ALL
2573:
2574: -- SHIPMENT CHANGES for Standard PO and Releases
2575: select
2576: pcr.change_request_id CHANGE_ID,
2577: pla.line_num LINE_NUM,
2578: pcr.document_shipment_number SHIPMENT_NUM,

Line 2752: if(l_type_lookup_code = 'STANDARD') then

2748: l_global_agreement_flag
2749: from po_headers_all
2750: where po_header_id = l_header_id;
2751:
2752: if(l_type_lookup_code = 'STANDARD') then
2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
2754: elsif(l_type_lookup_code = 'PLANNED') then
2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
2756: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 3358: -- LINE CHANGES for Standard PO

3354: REASON,
3355: SPLIT
3356: from(
3357:
3358: -- LINE CHANGES for Standard PO
3359: select
3360: pcr.document_line_number LINE_NUM,
3361: pcr.document_shipment_number SHIPMENT_NUM,
3362: msi.concatenated_segments BUYER_PT_NUM,

Line 3395: -- SHIPMENT CHANGES for Standard PO and Releases

3391: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
3392: AND FSP.ORG_ID = PLA.ORG_ID
3393: UNION ALL
3394:
3395: -- SHIPMENT CHANGES for Standard PO and Releases
3396: select
3397: pla.line_num LINE_NUM,
3398: pcr.document_shipment_number SHIPMENT_NUM,
3399: msi.concatenated_segments BUYER_PT_NUM,

Line 3502: -- SHIPMENT ACCEPTANCE/REJECTION for Standard PO

3498: UOM,
3499: SHIP_TO_LOCATION,
3500: NOTE
3501: from(
3502: -- SHIPMENT ACCEPTANCE/REJECTION for Standard PO
3503: select
3504: pla.line_num LINE_NUM,
3505: plla.shipment_num SHIPMENT_NUM,
3506: msi.concatenated_segments BUYER_PT_NUM,

Line 3670: if(l_type_lookup_code = 'STANDARD') then

3666: l_global_agreement_flag
3667: from po_headers_all
3668: where po_header_id = l_header_id;
3669:
3670: if(l_type_lookup_code = 'STANDARD') then
3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3672: elsif(l_type_lookup_code = 'PLANNED') then
3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
3674: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 4429: -- Respond to Changes on Line for Standard PO

4425: REASON,
4426: SPLIT,
4427: ACTION_CODE
4428: from(
4429: -- Respond to Changes on Line for Standard PO
4430: select
4431: pcr.document_line_number LINE_NUM,
4432: pcr.document_shipment_number SHIPMENT_NUM,
4433: pcr.old_supplier_part_number OLD_SUP_PT_NUM,

Line 4456: --Respond to changes on Shipment for Releases AND Standard PO

4452: --and pcr.document_revision_num = pla.revision_num
4453: and pcr.request_level = 'LINE'
4454: and pla.latest_external_flag = 'Y'
4455: UNION ALL
4456: --Respond to changes on Shipment for Releases AND Standard PO
4457: select
4458: pla.line_num LINE_NUM,
4459: pcr.document_shipment_number SHIPMENT_NUM,
4460: pla.vendor_product_num OLD_SUP_PT_NUM,

Line 4683: if(l_type_lookup_code = 'STANDARD') then

4679: l_progress := '003';
4680: if (display_type = 'text/html') then
4681:
4682: if(l_po_release_id is null) then
4683: if(l_type_lookup_code = 'STANDARD') then
4684: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num;
4685: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
4687: elsif(l_type_lookup_code = 'BLANKET') then

Line 5228: if(l_type_lookup_code = 'STANDARD') then

5224: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5225: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5226:
5227: IF( l_display_name IS NULL) THEN
5228: if(l_type_lookup_code = 'STANDARD') then
5229: l_message_name := 'PO_WF_NOTIF_STD_PO';
5230: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
5231: l_message_name := 'PO_GA_TYPE';
5232: elsif(l_type_lookup_code = 'BLANKET') then

Line 5433: if(l_type_lookup_code = 'STANDARD') then

5429: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5430: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5431:
5432: IF(l_display_name IS NULL) THEN
5433: if(l_type_lookup_code = 'STANDARD') then
5434: l_message_name := 'PO_WF_NOTIF_STD_PO';
5435: elsif(l_type_lookup_code = 'PLANNED') then
5436: l_message_name := 'PO_WF_NOTIF_PLAN_PO';
5437: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 5600: if(l_type_lookup_code = 'STANDARD') then

5596: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5597: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5598:
5599: IF(l_display_name IS NULL) THEN
5600: if(l_type_lookup_code = 'STANDARD') then
5601: l_message_name := 'PO_WF_NOTIF_STD_PO';
5602: elsif(l_type_lookup_code = 'PLANNED') then
5603: l_message_name := 'PO_WF_NOTIF_PLAN_PO';
5604: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 5756: if(l_type_lookup_code = 'STANDARD') then

5752: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5753: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5754:
5755: IF(l_display_name IS NULL) THEN
5756: if(l_type_lookup_code = 'STANDARD') then
5757: l_message_name := 'PO_WF_NOTIF_STD_PO';
5758: elsif(l_type_lookup_code = 'PLANNED') then
5759: l_message_name := 'PO_WF_NOTIF_PLAN_PO';
5760: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 6445: if(l_type_lookup_code = 'STANDARD') then

6441: l_header_cancel := 'Y';
6442: end if;
6443: end if;
6444:
6445: if(l_type_lookup_code = 'STANDARD') then
6446: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num;
6447: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
6449: elsif(l_type_lookup_code = 'BLANKET') then

Line 6814: elsif(l_doc_subtype in ('PLANNED','STANDARD')) then

6810: where po_header_id = l_header_id;
6811:
6812: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
6813: l_doc_type := 'PA';
6814: elsif(l_doc_subtype in ('PLANNED','STANDARD')) then
6815: l_doc_type := 'PO';
6816: end if;
6817: else
6818: l_doc_id := l_release_id;

Line 7386: elsif(l_doc_subtype = 'PLANNED' or l_doc_subtype = 'STANDARD') then

7382: where poh.po_header_id = p_header_id ;
7383:
7384: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
7385: l_doc_type := 'PA';
7386: elsif(l_doc_subtype = 'PLANNED' or l_doc_subtype = 'STANDARD') then
7387: l_doc_type := 'PO';
7388: end if;
7389: end if;
7390: initialize(l_agent_id, l_org_id);

Line 7610: and pll.shipment_type = 'STANDARD'

7606: where pcr.change_request_group_id = grp_id
7607: and pcr.request_level = 'LINE'
7608: and pcr.document_line_id = pda.po_line_id
7609: and pda.line_location_id = pll.line_location_id
7610: and pll.shipment_type = 'STANDARD'
7611: union
7612: select pda.deliver_to_person_id
7613: from
7614: po_change_requests pcr,