APPS.INV_PROJECT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 849: po_req_distributions_all via po_requisition_lines_all table

845: Get_project_loc_for_prj_Req and
846: populate_project_info procedure.
847:
848: This procedure provides the project and task from
849: po_req_distributions_all via po_requisition_lines_all table
850: for the requisition_line_id in the
851: mtl_material_transactions_temp or the
852: transaction interface table.
853: */

Line 868: FROM po_req_distributions_all

864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: SELECT project_id,task_id
867: INTO l_req_project_id,l_req_task_id
868: FROM po_req_distributions_all
869: WHERE requisition_line_id = p_req_line_id;
870:
871: x_project_id := l_req_project_id;
872: x_task_id := l_req_task_id;

Line 888: This procedure gets the project and task from po_req_distributions_all

884: /*
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(

Line 906: FROM po_req_distributions_all prd,

902: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: