APPS.PO_APPROVAL_ACTION dependencies on PO_REQ_DISTRIBUTIONS

Line 393: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD

389: WHERE PRL.requisition_header_id = l_document_id
390: AND nvl(PRL.cancel_flag,'N') = 'N'
391: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
392: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'
393: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD
394: WHERE PRD.requisition_line_id = PRL.requisition_line_id)
395: AND rownum=1;
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN

Line 418: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD

414: WHERE PRL.requisition_header_id = l_document_id
415: AND nvl(PRL.cancel_flag,'N') = 'N'
416: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
417: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'
418: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD
419: WHERE PRD.requisition_line_id = PRL.requisition_line_id);
420:
421: l_error_occur := 'N';
422:

Line 433: PO_REQ_DISTRIBUTIONS PRD,po_requisition_lines_clm_v PRL

429: /* Commented the following sql in bug 5864807
430: SELECT 'Y'
431: INTO l_error_occur
432: FROM
433: PO_REQ_DISTRIBUTIONS PRD,po_requisition_lines_clm_v PRL
434: WHERE
435: PRL.requisition_line_id = PRD.requisition_line_id AND
436: PRL.requisition_header_id = l_document_id AND
437: nvl(PRL.cancel_flag,'N') = 'N'

Line 442: FROM PO_REQ_DISTRIBUTIONS PRD

438: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
439: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
440: PRL.quantity <> (SELECT
441: sum(PRD.req_line_quantity)
442: FROM PO_REQ_DISTRIBUTIONS PRD
443: WHERE
444: PRD.requisition_line_id = PRL.requisition_line_id)
445: AND rownum=1; */
446:

Line 461: FROM PO_REQ_DISTRIBUTIONS PRD

457: --Start Bug 13065293
458: round(PRL.quantity,15) <> (SELECT
459: round(sum(PRD.req_line_quantity),15)
460: --End Bug 13065293
461: FROM PO_REQ_DISTRIBUTIONS PRD
462: WHERE
463: PRD.requisition_line_id = PRL.requisition_line_id
464: GROUP BY PRD.requisition_line_id)
465: AND rownum=1;

Line 486: PO_REQ_DISTRIBUTIONS PRD,po_requisition_lines_clm_v PRL

482: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
483: 'Line #' || PRL.line_num ||' Quantity '|| to_char (PRL.quantity) || ' ' ||
484: l_msg_text || ' ' || to_char(sum(PRD.req_line_quantity))
485: FROM
486: PO_REQ_DISTRIBUTIONS PRD,po_requisition_lines_clm_v PRL
487: WHERE
488: PRL.requisition_line_id = PRD.requisition_line_id AND
489: PRL.requisition_header_id = l_document_id AND
490: nvl(PRL.cancel_flag,'N') = 'N'

Line 495: FROM PO_REQ_DISTRIBUTIONS PRD

491: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
492: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
493: PRL.quantity <> (SELECT
494: sum(PRD.req_line_quantity)
495: FROM PO_REQ_DISTRIBUTIONS PRD
496: WHERE
497: PRD.requisition_line_id = PRL.requisition_line_id)
498: GROUP BY PRL.line_num,PRL.quantity;
499: l_error_occur := 'N';

Line 518: 1 < (select count(PRD.requisition_line_id) FROM PO_REQ_DISTRIBUTIONS

514: FROM po_requisition_lines_clm_v PRL
515: WHERE PRL.requisition_header_id = l_document_id
516: AND PRL.source_type_code = 'INVENTORY' AND nvl(PRL.cancel_flag,'N')
517: = 'N' AND nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
518: 1 < (select count(PRD.requisition_line_id) FROM PO_REQ_DISTRIBUTIONS
519: PRD WHERE PRD.requisition_line_id = PRL.requisition_line_id);
520:
521: x_progress := 'req_complete_check 008';
522:

Line 583: , PO_REQ_DISTRIBUTIONS PRD

579: , l_sequence
580: , 'Line #'||PRL.line_num||' Distribution '||PRD.distribution_num||' '||l_msg_text
581: FROM
582: FINANCIALS_SYSTEM_PARAMETERS FSP
583: , PO_REQ_DISTRIBUTIONS PRD
584: , po_requisition_lines_clm_v PRL
585: , PO_REQUISITION_HEADERS_ALL PRH
586: WHERE PRD.requisition_line_id = PRL.requisition_line_id
587: AND PRL.requisition_header_id = PRH.requisition_header_id