DBA Data[Home] [Help]

APPS.PO_APPROVAL_ACTION dependencies on FINANCIALS_SYSTEM_PARAMETERS

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 582: FINANCIALS_SYSTEM_PARAMETERS FSP

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