DBA Data[Home] [Help]

APPS.RCV_DISTRIBUTIONS_S dependencies on PO_REQUISITION_LINES

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

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