APPS.PO_COMM_FPDSNG_PVT dependencies on PO_RELEASES_ALL

Line 166: FROM po_releases_all pr

162:
163: IF l_document_type='RELEASE' AND l_document_subtype = 'BLANKET' THEN
164:
165: SELECT pr.po_header_id, pr.release_num INTO l_document_id, l_release_num
166: FROM po_releases_all pr
167: WHERE pr.po_release_id = l_document_id;
168:
169: IF g_debug_stmt THEN
170: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_document_id', l_document_id );

Line 313: FROM po_releases_all

309:
310: BEGIN
311: l_progress:='005';
312: SELECT po_release_id INTO PO_COMM_FPDSNG_PVT.g_release_id
313: FROM po_releases_all
314: WHERE po_header_id=p_document_id AND
315: release_num= p_release_num;
316: EXCEPTION
317: WHEN NO_DATA_FOUND THEN

Line 361: po_releases_all por where por.po_release_id=pod.po_release_id

357: l_progress:='010';
358: l_dollarValueQuery:='SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
359: po_core_s.get_total(''R'', PO_COMM_FPDSNG_PVT.getReleaseId()) baseAndExcercisedOptionsValue
360: from po_distributions_all pod,
361: po_releases_all por where por.po_release_id=pod.po_release_id
362: and por.po_release_id =PO_COMM_FPDSNG_PVT.getReleaseId()';
363:
364: ELSE
365: l_progress:='011';

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 408: po_lines_all pol, po_releases_all por

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 (+)
412: and mck.category_id = pol.category_id

Line 732: FROM po_releases_all

728: ELSE
729: IF p_release_num < 0 THEN
730: l_progress := '004';
731: SELECT release_num INTO l_release_num
732: FROM po_releases_all
733: WHERE po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId();
734: ELSE
735: l_progress := '005';
736: l_release_num := p_release_num;

Line 1141: from po_releases_all pr

1137:
1138: ELSIF p_document_type in ('RELEASE') THEN
1139: l_progress := '002';
1140: select pr.po_header_id, pr.release_num into l_header_id, l_release_num
1141: from po_releases_all pr
1142: where pr.po_release_id = p_document_id;
1143:
1144: END IF;
1145: