APPS.PO_APPROVAL_ACTION dependencies on PO_REQ_DISTRIBUTIONS

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

352: WHERE PRL.requisition_header_id = l_document_id
353: AND nvl(PRL.cancel_flag,'N') = 'N'
354: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
355: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'
356: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD
357: WHERE PRD.requisition_line_id = PRL.requisition_line_id)
358: AND rownum=1;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN

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

377: WHERE PRL.requisition_header_id = l_document_id
378: AND nvl(PRL.cancel_flag,'N') = 'N'
379: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED'
380: AND nvl(PRL.modified_by_agent_flag,'N') = 'N'
381: AND NOT EXISTS (SELECT 'Dist Exist' FROM PO_REQ_DISTRIBUTIONS PRD
382: WHERE PRD.requisition_line_id = PRL.requisition_line_id);
383:
384: l_error_occur := 'N';
385:

Line 396: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL

392: /* Commented the following sql in bug 5864807
393: SELECT 'Y'
394: INTO l_error_occur
395: FROM
396: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL
397: WHERE
398: PRL.requisition_line_id = PRD.requisition_line_id AND
399: PRL.requisition_header_id = l_document_id AND
400: nvl(PRL.cancel_flag,'N') = 'N'

Line 405: FROM PO_REQ_DISTRIBUTIONS PRD

401: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
402: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
403: PRL.quantity <> (SELECT
404: sum(PRD.req_line_quantity)
405: FROM PO_REQ_DISTRIBUTIONS PRD
406: WHERE
407: PRD.requisition_line_id = PRL.requisition_line_id)
408: AND rownum=1; */
409:

Line 422: FROM PO_REQ_DISTRIBUTIONS PRD

418: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
419: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
420: PRL.quantity <> (SELECT
421: sum(PRD.req_line_quantity)
422: FROM PO_REQ_DISTRIBUTIONS PRD
423: WHERE
424: PRD.requisition_line_id = PRL.requisition_line_id
425: GROUP BY PRD.requisition_line_id)
426: AND rownum=1;

Line 447: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL

443: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
444: 'Line #' || PRL.line_num ||' Quantity '|| to_char (PRL.quantity) || ' ' ||
445: l_msg_text || ' ' || to_char(sum(PRD.req_line_quantity))
446: FROM
447: PO_REQ_DISTRIBUTIONS PRD,PO_REQUISITION_LINES PRL
448: WHERE
449: PRL.requisition_line_id = PRD.requisition_line_id AND
450: PRL.requisition_header_id = l_document_id AND
451: nvl(PRL.cancel_flag,'N') = 'N'

Line 456: FROM PO_REQ_DISTRIBUTIONS PRD

452: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
453: nvl(PRL.modified_by_agent_flag,'N') = 'N' AND
454: PRL.quantity <> (SELECT
455: sum(PRD.req_line_quantity)
456: FROM PO_REQ_DISTRIBUTIONS PRD
457: WHERE
458: PRD.requisition_line_id = PRL.requisition_line_id)
459: GROUP BY PRL.line_num,PRL.quantity;
460: l_error_occur := 'N';

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

475: FROM PO_REQUISITION_LINES PRL
476: WHERE PRL.requisition_header_id = l_document_id
477: AND PRL.source_type_code = 'INVENTORY' AND nvl(PRL.cancel_flag,'N')
478: = 'N' AND nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
479: 1 < (select count(PRD.requisition_line_id) FROM PO_REQ_DISTRIBUTIONS
480: PRD WHERE PRD.requisition_line_id = PRL.requisition_line_id);
481:
482: x_progress := 'req_complete_check 008';
483:

Line 541: , PO_REQ_DISTRIBUTIONS PRD

537: , l_sequence
538: , 'Line #'||PRL.line_num||' Distribution '||PRD.distribution_num||' '||l_msg_text
539: FROM
540: FINANCIALS_SYSTEM_PARAMETERS FSP
541: , PO_REQ_DISTRIBUTIONS PRD
542: , PO_REQUISITION_LINES PRL
543: , PO_REQUISITION_HEADERS_ALL PRH
544: WHERE PRD.requisition_line_id = PRL.requisition_line_id
545: AND PRL.requisition_header_id = PRH.requisition_header_id