APPS.PO_APPROVAL_ACTION dependencies on PO_REQUISITION_LINES_CLM_V

Line 231: UPDATE po_requisition_lines_clm_v PORL

227: pragma AUTONOMOUS_TRANSACTION;
228:
229: begin
230:
231: UPDATE po_requisition_lines_clm_v PORL
232: SET PORL.last_update_date = sysdate,
233: PORL.last_updated_by = p_user_id,
234: PORL.last_update_login = p_last_update_login,
235: PORL.rate =

Line 353: AND NOT EXISTS (SELECT 'Lines Exist' FROM po_requisition_lines_clm_v

349: into l_error_occur
350: FROM
351: PO_REQUISITION_HEADERS PRH
352: WHERE PRH.requisition_header_id = l_document_id
353: AND NOT EXISTS (SELECT 'Lines Exist' FROM po_requisition_lines_clm_v
354: PRL WHERE PRL.requisition_header_id = PRH.requisition_header_id
355: AND nvl(PRL.cancel_flag,'N') = 'N');
356:
357: EXCEPTION

Line 388: po_requisition_lines_clm_v PRL

384:
385: SELECT 'Y'
386: INTO l_error_occur
387: FROM
388: po_requisition_lines_clm_v PRL
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'

Line 413: po_requisition_lines_clm_v PRL

409: SELECT
410: l_online_report_id, l_last_update_login, l_user_id, sysdate,
411: l_user_id,sysdate,PRL.line_num,0,0,l_sequence, 'Line #' || PRL.line_num ||' ' || l_msg_text
412: FROM
413: po_requisition_lines_clm_v PRL
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'

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 451: po_requisition_lines_clm_v PRL

447: -- Added the following sql for bug 5864807
448: SELECT 'Y'
449: INTO l_error_occur
450: FROM
451: po_requisition_lines_clm_v PRL
452: WHERE
453: PRL.requisition_header_id = l_document_id AND
454: nvl(PRL.cancel_flag,'N') = 'N'
455: AND nvl(PRL.closed_code,'OPEN') <> 'FINALLY CLOSED' AND

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 514: FROM po_requisition_lines_clm_v PRL

510: shipment_num, distribution_num, sequence, text_line) SELECT
511: l_online_report_id,l_last_update_login,l_last_user_id, sysdate,
512: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
513: 'Line #' ||PRL.line_num||' '|| l_msg_text
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

Line 534: FROM po_requisition_lines_clm_v PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

530: SELECT
531: l_online_report_id,l_last_update_login,l_user_id, sysdate,
532: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
533: 'Line #' ||PRL.line_num||' '||l_msg_text
534: FROM po_requisition_lines_clm_v PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
535: GL_SETS_OF_BOOKS SOB
536: WHERE PRL.requisition_header_id = l_document_id AND
537: nvl(PRL.cancel_flag, 'N') = 'N' AND nvl(PRL.closed_code, 'OPEN') <>
538: 'FINALLY CLOSED' AND SOB.set_of_books_id = FSP.set_of_books_id AND

Line 584: , po_requisition_lines_clm_v PRL

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
588: AND PRL.requisition_header_id = l_document_id