DBA Data[Home] [Help]

APPS.RCV_DISTRIBUTIONS_S dependencies on PO_REQUISITION_LINES

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 812: FROM po_requisition_lines PRL,

808: x_dest_subinv,
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