APPS.PO_CREATE_ISO dependencies on PO_REQ_DISTRIBUTIONS

Line 75: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;

71: l_val_proj_error_code VARCHAR2(80);
72: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;
73: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;
74: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;
75: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;
76: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;
77: -- Bug 2873877 END
78:
79: --

Line 76: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;

72: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;
73: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;
74: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;
75: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;
76: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;
77: -- Bug 2873877 END
78:
79: --
80: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;

Line 382: FROM po_requisition_lines PRL, po_req_distributions PRD

378: l_task_id,
379: l_dest_secondary_quantity ,
380: l_dest_secondary_unit ,
381: l_item_id
382: FROM po_requisition_lines PRL, po_req_distributions PRD
383: WHERE PRL.requisition_line_id = l_req_line_id
384: AND PRL.requisition_line_id = PRD.requisition_line_id; -- JOIN
385:
386: -- Note: Internal lines can only have one distribution. This

Line 609: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!

605: decode(si.grade_control_flag,'Y',RL.preferred_grade,NULL) -- RL.PREFERRED_GRADE
606: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
607: FROM PO_REQUISITION_LINES RL,
608: PO_REQUISITION_HEADERS RH,
609: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
610: MTL_SYSTEM_ITEMS SI,
611: PO_LOCATION_ASSOCIATIONS_ALL LA,
612: MTL_UNITS_OF_MEASURE MUM
613: --,MTL_UNITS_OF_MEASURE MUM1