APPS.PO_CREATE_ISO dependencies on PO_REQ_DISTRIBUTIONS

Line 78: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;

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

Line 79: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;

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

Line 112: l_conversion_date PO_REQ_DISTRIBUTIONS.gl_encumbered_date%TYPE;

108:
109: --BUG10037733 variable definitions.
110: l_unit_list_price number;
111: l_unit_selling_price number;
112: l_conversion_date PO_REQ_DISTRIBUTIONS.gl_encumbered_date%TYPE;
113: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
114: l_conversion_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
115: l_rate NUMBER;
116: l_source_currency_code VARCHAR2(15);

Line 450: FROM po_requisition_lines PRL, po_req_distributions PRD

446: l_task_id,
447: l_dest_secondary_quantity ,
448: l_dest_secondary_unit ,
449: l_item_id
450: FROM po_requisition_lines PRL, po_req_distributions PRD
451: WHERE PRL.requisition_line_id = l_req_line_id
452: AND PRL.requisition_line_id = PRD.requisition_line_id; -- JOIN
453:
454: -- Note: Internal lines can only have one distribution. This

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

737: decode(si.grade_control_flag,'Y',RL.preferred_grade,NULL) -- RL.PREFERRED_GRADE
738: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
739: FROM PO_REQUISITION_LINES RL,
740: PO_REQUISITION_HEADERS RH,
741: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
742: MTL_SYSTEM_ITEMS SI,
743: PO_LOCATION_ASSOCIATIONS_ALL LA,
744: MTL_UNITS_OF_MEASURE MUM
745: --,MTL_UNITS_OF_MEASURE MUM1