APPS.INV_PROJECT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 854: po_req_distributions_all via po_requisition_lines_all table

850: Get_project_loc_for_prj_Req and
851: populate_project_info procedure.
852:
853: This procedure provides the project and task from
854: po_req_distributions_all via po_requisition_lines_all table
855: for the requisition_line_id in the
856: mtl_material_transactions_temp or the
857: transaction interface table.
858: */

Line 873: FROM po_req_distributions_all

869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870:
871: SELECT project_id,task_id
872: INTO l_req_project_id,l_req_task_id
873: FROM po_req_distributions_all
874: WHERE requisition_line_id = p_req_line_id;
875:
876: x_project_id := l_req_project_id;
877: x_task_id := l_req_task_id;

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

889: /*
890: The Get_project_info_for_RcvTrx procedure is called in procedures
891: populate_project_info procedure.
892:
893: This procedure gets the project and task from po_req_distributions_all
894: via rcv_transactions table for the rcv_transaction_id in the
895: mtl_material_transactions_temp.
896: */
897: Procedure Get_project_info_for_RcvTrx(

Line 911: FROM po_req_distributions_all prd,

907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: SELECT prd.project_id, prd.task_id
910: INTO l_req_project_id,l_req_task_id
911: FROM po_req_distributions_all prd,
912: rcv_transactions rcv
913: WHERE rcv.transaction_id = P_Rcv_Trx_Id
914: And prd.requisition_line_id = rcv.requisition_line_id;
915: