DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on RCV_TRANSACTIONS

Line 889: via rcv_transactions table for the rcv_transaction_id in the

885: The Get_project_info_for_RcvTrx procedure is called in procedures
886: populate_project_info procedure.
887:
888: This procedure gets the project and task from po_req_distributions_all
889: via rcv_transactions table for the rcv_transaction_id in the
890: mtl_material_transactions_temp.
891: */
892: Procedure Get_project_info_for_RcvTrx(
893: x_Return_Status Out NOCOPY Varchar2,

Line 907: rcv_transactions rcv

903:
904: SELECT prd.project_id, prd.task_id
905: INTO l_req_project_id,l_req_task_id
906: FROM po_req_distributions_all prd,
907: rcv_transactions rcv
908: WHERE rcv.transaction_id = P_Rcv_Trx_Id
909: And prd.requisition_line_id = rcv.requisition_line_id;
910:
911: x_project_id := l_req_project_id;