APPS.RCV_DISTRIBUTIONS_S dependencies on PO_REQ_DISTRIBUTIONS

Line 797: * values in PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS

793:
794: /**
795: * Public Procedure: get_misc_req_distr_info
796: * Requires: p_requisition_line_id and p_req_distribution_id should be valid
797: * values in PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS
798: * Modifies: None
799: * Effects: get kanban card information from req line, project, task and
800: * charge account information from req distribution
801: * Returns:

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

829: x_dest_subinv OUT NOCOPY VARCHAR2) IS
830:
831: l_api_name CONSTANT VARCHAR2(50) := 'get_misc_req_distr_info';
832: l_progress VARCHAR2(3) := '000';
833: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151
834: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151
835: BEGIN
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:

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

830:
831: l_api_name CONSTANT VARCHAR2(50) := 'get_misc_req_distr_info';
832: l_progress VARCHAR2(3) := '000';
833: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151
834: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151
835: BEGIN
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: IF (p_requisition_line_id IS NOT NULL) THEN

Line 864: po_req_distributions PRD,

860: x_project_id, -- bug 3867151
861: x_task_id, -- bug 3867151
862: x_charge_account
863: FROM po_requisition_lines PRL,
864: po_req_distributions PRD,
865: mtl_kanban_cards MKC
866: WHERE PRL.requisition_line_id = p_requisition_line_id
867: AND PRL.requisition_line_id = PRD.requisition_line_id
868: AND PRD.distribution_id = NVL(p_req_distribution_id,PRD.distribution_id)