APPS.RCV_DISTRIBUTIONS_S dependencies on PO_REQ_DISTRIBUTIONS

Line 746: * values in PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS

742:
743: /**
744: * Public Procedure: get_misc_req_distr_info
745: * Requires: p_requisition_line_id and p_req_distribution_id should be valid
746: * values in PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS
747: * Modifies: None
748: * Effects: get kanban card information from req line, project, task and
749: * charge account information from req distribution
750: * Returns:

Line 782: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151

778: x_dest_subinv OUT NOCOPY VARCHAR2) IS
779:
780: l_api_name CONSTANT VARCHAR2(50) := 'get_misc_req_distr_info';
781: l_progress VARCHAR2(3) := '000';
782: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151
783: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151
784: BEGIN
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:

Line 783: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151

779:
780: l_api_name CONSTANT VARCHAR2(50) := 'get_misc_req_distr_info';
781: l_progress VARCHAR2(3) := '000';
782: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151
783: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151
784: BEGIN
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: IF (p_requisition_line_id IS NOT NULL) THEN

Line 813: po_req_distributions PRD,

809: x_project_id, -- bug 3867151
810: x_task_id, -- bug 3867151
811: x_charge_account
812: FROM po_requisition_lines PRL,
813: po_req_distributions PRD,
814: mtl_kanban_cards MKC
815: WHERE PRL.requisition_line_id = p_requisition_line_id
816: AND PRL.requisition_line_id = PRD.requisition_line_id
817: AND PRD.distribution_id = NVL(p_req_distribution_id,PRD.distribution_id)