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 688: if(l_type_lookup_code = 'STANDARD') then

684: from po_headers_all
685: where po_header_id = l_can_hdr_id;
686: if(l_can_rel_id is null) then
687: l_can_doc_type := 'PO';
688: if(l_type_lookup_code = 'STANDARD') then
689: l_can_doc_subtype := 'STANDARD';
690: elsif(l_type_lookup_code = 'PLANNED') then
691: l_can_doc_subtype := 'PLANNED';
692: elsif(l_type_lookup_code = 'BLANKET') then

Line 689: l_can_doc_subtype := 'STANDARD';

685: where po_header_id = l_can_hdr_id;
686: if(l_can_rel_id is null) then
687: l_can_doc_type := 'PO';
688: if(l_type_lookup_code = 'STANDARD') then
689: l_can_doc_subtype := 'STANDARD';
690: elsif(l_type_lookup_code = 'PLANNED') then
691: l_can_doc_subtype := 'PLANNED';
692: elsif(l_type_lookup_code = 'BLANKET') then
693: l_can_doc_type := 'PA';

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

749: from po_headers_all
750: where po_header_id = l_can_hdr_id;
751: if(l_can_rel_id is null) then
752: l_can_doc_type := 'PO';
753: if(l_type_lookup_code = 'STANDARD') then
754: l_can_doc_subtype := 'STANDARD';
755: elsif(l_type_lookup_code = 'PLANNED') then
756: l_can_doc_subtype := 'PLANNED';
757: elsif(l_type_lookup_code = 'BLANKET') then

Line 754: l_can_doc_subtype := 'STANDARD';

750: where po_header_id = l_can_hdr_id;
751: if(l_can_rel_id is null) then
752: l_can_doc_type := 'PO';
753: if(l_type_lookup_code = 'STANDARD') then
754: l_can_doc_subtype := 'STANDARD';
755: elsif(l_type_lookup_code = 'PLANNED') then
756: l_can_doc_subtype := 'PLANNED';
757: elsif(l_type_lookup_code = 'BLANKET') then
758: l_can_doc_type := 'PA';

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

1303: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
1304: l_api_name || '.start_wf_process', l_Item_Type||'*'||l_Item_Key);
1305: END IF;
1306:
1307: IF( (l_Document_Type_Code = 'RELEASE' AND l_Document_Subtype = 'BLANKET') OR (l_Document_Type_Code = 'PO' AND l_Document_Subtype = 'STANDARD') ) THEN
1308: l_CommunicatePriceChange := 'Y';
1309: END IF;
1310:
1311: PO_REQAPPROVAL_INIT1.Start_WF_Process(

Line 1556: -- LINE CHANGES for Standard PO

1552: REASON,
1553: SPLIT
1554: from(
1555:
1556: -- LINE CHANGES for Standard PO
1557: select
1558: pcr.document_line_number LINE_NUM,
1559: pcr.document_shipment_number SHIPMENT_NUM,
1560: msi.concatenated_segments BUYER_PT_NUM,

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

1592: where po_line_id = pcr.document_line_id
1593: and deliver_to_person_id = l_requestor_id)
1594: UNION ALL
1595:
1596: -- SHIPMENT CHANGES for Standard PO and Releases
1597: select
1598: pla.line_num LINE_NUM,
1599: pcr.document_shipment_number SHIPMENT_NUM,
1600: msi.concatenated_segments BUYER_PT_NUM,

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

1764: l_global_agreement_flag
1765: from po_headers_all
1766: where po_header_id = l_header_id;
1767:
1768: if(l_type_lookup_code = 'STANDARD') then
1769: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1770: elsif(l_type_lookup_code = 'PLANNED') then
1771: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1772: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 2382: -- LINE CHANGES for Standard PO

2378: REASON,
2379: SPLIT
2380: from(
2381:
2382: -- LINE CHANGES for Standard PO
2383: select
2384: pcr.change_request_id CHANGE_ID,
2385: pcr.document_line_number LINE_NUM,
2386: pcr.document_shipment_number SHIPMENT_NUM,

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

2420: and msi.organization_id = mtp.organization_id
2421: and mtp.employee_id = l_planner_id
2422: UNION ALL
2423:
2424: -- SHIPMENT CHANGES for Standard PO and Releases
2425: select
2426: pcr.change_request_id CHANGE_ID,
2427: pla.line_num LINE_NUM,
2428: pcr.document_shipment_number SHIPMENT_NUM,

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

2597: l_global_agreement_flag
2598: from po_headers_all
2599: where po_header_id = l_header_id;
2600:
2601: if(l_type_lookup_code = 'STANDARD') then
2602: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
2603: elsif(l_type_lookup_code = 'PLANNED') then
2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
2605: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

Line 3206: -- LINE CHANGES for Standard PO

3202: REASON,
3203: SPLIT
3204: from(
3205:
3206: -- LINE CHANGES for Standard PO
3207: select
3208: pcr.document_line_number LINE_NUM,
3209: pcr.document_shipment_number SHIPMENT_NUM,
3210: msi.concatenated_segments BUYER_PT_NUM,

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

3239: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
3240: AND FSP.ORG_ID = PLA.ORG_ID
3241: UNION ALL
3242:
3243: -- SHIPMENT CHANGES for Standard PO and Releases
3244: select
3245: pla.line_num LINE_NUM,
3246: pcr.document_shipment_number SHIPMENT_NUM,
3247: msi.concatenated_segments BUYER_PT_NUM,

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

3346: UOM,
3347: SHIP_TO_LOCATION,
3348: NOTE
3349: from(
3350: -- SHIPMENT ACCEPTANCE/REJECTION for Standard PO
3351: select
3352: pla.line_num LINE_NUM,
3353: plla.shipment_num SHIPMENT_NUM,
3354: msi.concatenated_segments BUYER_PT_NUM,

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

3514: l_global_agreement_flag
3515: from po_headers_all
3516: where po_header_id = l_header_id;
3517:
3518: if(l_type_lookup_code = 'STANDARD') then
3519: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3520: elsif(l_type_lookup_code = 'PLANNED') then
3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
3522: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

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

4273: REASON,
4274: SPLIT,
4275: ACTION_CODE
4276: from(
4277: -- Respond to Changes on Line for Standard PO
4278: select
4279: pcr.document_line_number LINE_NUM,
4280: pcr.document_shipment_number SHIPMENT_NUM,
4281: pcr.old_supplier_part_number OLD_SUP_PT_NUM,

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

4300: --and pcr.document_revision_num = pla.revision_num
4301: and pcr.request_level = 'LINE'
4302: and pla.latest_external_flag = 'Y'
4303: UNION ALL
4304: --Respond to changes on Shipment for Releases AND Standard PO
4305: select
4306: pla.line_num LINE_NUM,
4307: pcr.document_shipment_number SHIPMENT_NUM,
4308: pla.vendor_product_num OLD_SUP_PT_NUM,

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

4527: l_progress := '003';
4528: if (display_type = 'text/html') then
4529:
4530: if(l_po_release_id is null) then
4531: if(l_type_lookup_code = 'STANDARD') then
4532: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num;
4533: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
4535: elsif(l_type_lookup_code = 'BLANKET') then

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

5072: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5073: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5074:
5075: IF( l_display_name IS NULL) THEN
5076: if(l_type_lookup_code = 'STANDARD') then
5077: l_message_name := 'PO_WF_NOTIF_STD_PO';
5078: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
5079: l_message_name := 'PO_GA_TYPE';
5080: elsif(l_type_lookup_code = 'BLANKET') then

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

5275: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5276: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5277:
5278: IF(l_display_name IS NULL) THEN
5279: if(l_type_lookup_code = 'STANDARD') then
5280: l_message_name := 'PO_WF_NOTIF_STD_PO';
5281: elsif(l_type_lookup_code = 'PLANNED') then
5282: l_message_name := 'PO_WF_NOTIF_PLAN_PO';
5283: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

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

5442: AND PDSL.ENABLED_FLAG (+) = 'Y' AND PDSL.STATUS (+) = 'ACTIVE'
5443: AND PDSL.LANGUAGE (+) = USERENV('LANG');
5444:
5445: IF(l_display_name IS NULL) THEN
5446: if(l_type_lookup_code = 'STANDARD') then
5447: l_message_name := 'PO_WF_NOTIF_STD_PO';
5448: elsif(l_type_lookup_code = 'PLANNED') then
5449: l_message_name := 'PO_WF_NOTIF_PLAN_PO';
5450: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then

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

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

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

6283: l_header_cancel := 'Y';
6284: end if;
6285: end if;
6286:
6287: if(l_type_lookup_code = 'STANDARD') then
6288: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num;
6289: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
6291: elsif(l_type_lookup_code = 'BLANKET') then

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

6652: where po_header_id = l_header_id;
6653:
6654: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
6655: l_doc_type := 'PA';
6656: elsif(l_doc_subtype in ('PLANNED','STANDARD')) then
6657: l_doc_type := 'PO';
6658: end if;
6659: else
6660: l_doc_id := l_release_id;

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

7224: where poh.po_header_id = p_header_id ;
7225:
7226: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
7227: l_doc_type := 'PA';
7228: elsif(l_doc_subtype = 'PLANNED' or l_doc_subtype = 'STANDARD') then
7229: l_doc_type := 'PO';
7230: end if;
7231: end if;
7232: initialize(l_agent_id, l_org_id);

Line 7452: and pll.shipment_type = 'STANDARD'

7448: where pcr.change_request_group_id = grp_id
7449: and pcr.request_level = 'LINE'
7450: and pcr.document_line_id = pda.po_line_id
7451: and pda.line_location_id = pll.line_location_id
7452: and pll.shipment_type = 'STANDARD'
7453: union
7454: select pda.deliver_to_person_id
7455: from
7456: po_change_requests pcr,