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

Line 285: FROM po_headers_all ph

281: PO_COMM_FPDSNG_PVT.g_document_id := p_document_id;
282:
283: l_progress:='001';
284: SELECT TYPE_LOOKUP_CODE into l_doc_type
285: FROM po_headers_all ph
286: WHERE po_header_id = p_document_id ;
287:
288: IF p_revision_num < 0 THEN
289: l_progress:='002';

Line 292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;

288: IF p_revision_num < 0 THEN
289: l_progress:='002';
290:
291: SELECT revision_num INTO PO_COMM_FPDSNG_PVT.g_revision_num
292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;
293:
294: ELSE
295: l_progress:='003';
296: PO_COMM_FPDSNG_PVT.g_revision_num := p_revision_num;

Line 348: FROM po_headers_all poh

344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
345: l_progress:='009';
346: l_ContractDatesQuery :=' SELECT poh.start_date effectiveDate,
347: poh.end_date lastDateToOrder
348: FROM po_headers_all poh
349: WHERE
350: poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
351: END IF;
352:

Line 369: po_headers_all poh where poh.po_header_id=pod.po_header_id

365: l_progress:='011';
366: l_dollarValueQuery := ' SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
367: po_core_s.get_total(''H'', PO_COMM_FPDSNG_PVT.getDocumentId()) baseAndExcercisedOptionsValue
368: from po_distributions_all pod,
369: po_headers_all poh where poh.po_header_id=pod.po_header_id
370: and poh.po_header_id =PO_COMM_FPDSNG_PVT.getDocumentId()';
371:
372: END IF;
373:

Line 376: FROM po_vendor_sites_all pov, po_headers_all poh

372: END IF;
373:
374: l_progress:='012';
375: l_contractMarketingQuery := 'SELECT pov.email_address emailAddress
376: FROM po_vendor_sites_all pov, po_headers_all poh
377: WHERE pov.vendor_site_id= poh.vendor_site_id
378: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
379:
380: l_progress:='013';

Line 394: FROM po_headers_all poh, po_releases_all por

390: Greatest((poh.end_date - poh.start_date), 366),
391: 366,''false'',''true'')
392: ) multiYearContract,
393: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,poh.pcard_id,por.pcard_id) purchaseCardAsPaymentMethod
394: FROM po_headers_all poh, po_releases_all por
395: WHERE poh.po_header_id = por.po_header_id (+)
396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()
397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;
398:

Line 407: po_vendor_sites_all pvs, po_headers_all poh,

403: l_progress:='014';
404: l_ProductInfoQuery := 'SELECT mck.concatenated_segments productOrServiceCode,
405: fcv.naics_code1 principalNAICSCode
406: FROM fv_ccr_vendors fcv, mtl_categories_kfv mck,
407: po_vendor_sites_all pvs, po_headers_all poh,
408: po_lines_all pol, po_releases_all por
409: WHERE
410: poh.vendor_site_id = pvs.vendor_site_id
411: and pvs.duns_number = fcv.duns (+)

Line 425: po_vendor_sites_all pvs, po_headers_all poh, po_lines_all pol

421: l_progress:='015';
422: l_ProductInfoQuery := 'SELECT mck.concatenated_segments productOrServiceCode,
423: fcv.naics_code1 principalNAICSCode
424: FROM fv_ccr_vendors fcv, mtl_categories_kfv mck,
425: po_vendor_sites_all pvs, po_headers_all poh, po_lines_all pol
426: WHERE poh.vendor_site_id = pvs.vendor_site_id
427: and pvs.duns_number = fcv.duns (+)
428: and mck.category_id = pol.category_id
429: and poh.po_header_id = pol.po_header_id

Line 436: FROM po_vendors pov, po_headers_all poh

432: END IF;
433:
434: l_progress:='016';
435: l_vendorHeaderQuery := 'SELECT vendor_name vendorName
436: FROM po_vendors pov, po_headers_all poh
437: WHERE pov.vendor_id= poh.vendor_id
438: AND poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
439:
440: l_progress:='017';

Line 446: FROM po_vendor_sites_all pov, po_headers_all poh

442: address_line1 streetAddress, address_line2 streetAddress2,
443: address_line3 streetAddress3, city, state, zip ZIPCode,
444: country countryCode, duns_number DUNSNumber,
445: (area_code) || phone phoneNo, (fax_area_code) || pov.fax faxNo
446: FROM po_vendor_sites_all pov, po_headers_all poh
447: WHERE pov.vendor_site_id = poh.vendor_site_id
448: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
449:
450:

Line 629: FROM po_headers_all ph

625:
626: IF l_org_id is null THEN
627: l_progress:='042';
628: SELECT ph.org_id into l_org_id
629: FROM po_headers_all ph
630: WHERE po_header_id = p_document_id;
631: END IF;
632:
633: --Get the Language

Line 692: l_po_number po_headers_all.segment1%type;

688: p_release_num number,
689: p_language_code varchar2) RETURN varchar2 IS
690:
691: l_api_name CONSTANT VARCHAR2(25):= 'getFPDSNGFileName';
692: l_po_number po_headers_all.segment1%type;
693: l_file_name fnd_lobs.file_name%type;
694: l_extension VARCHAR2(15);
695: l_doc_type VARCHAR2(10);
696: l_progress VARCHAR2(3);

Line 714: FROM po_headers_all ph

710: l_progress := '001';
711: -- Query for getting the PO number i.e segment1.
712: l_progress := '002';
713: SELECT ph.segment1 into l_po_number
714: FROM po_headers_all ph
715: WHERE po_header_id = p_document_id;
716:
717: IF g_debug_stmt THEN
718: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_po_number', l_po_number);