DBA Data[Home] [Help]

APPS.PO_APPROVAL_ACTION dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 495: FROM PO_REQUISITION_LINES PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

491: SELECT
492: l_online_report_id,l_last_update_login,l_user_id, sysdate,
493: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
494: 'Line #' ||PRL.line_num||' '||l_msg_text
495: FROM PO_REQUISITION_LINES PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
496: GL_SETS_OF_BOOKS SOB
497: WHERE PRL.requisition_header_id = l_document_id AND
498: nvl(PRL.cancel_flag, 'N') = 'N' AND nvl(PRL.closed_code, 'OPEN') <>
499: 'FINALLY CLOSED' AND SOB.set_of_books_id = FSP.set_of_books_id AND

Line 540: FINANCIALS_SYSTEM_PARAMETERS FSP

536: , PRD.distribution_num
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