DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on HR_LOCATIONS

Line 270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;

266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
271: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
272: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;
273: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;
274: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%TYPE;

Line 388: hr_locations_all hrl,

384: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
385: FROM po_lines pol,
386: po_line_locations pll,
387: mtl_system_items_kfv msi,
388: hr_locations_all hrl,
389: hz_locations hz,
390: org_organization_definitions ood,
391: mtl_units_of_measure muom, -- Bug 2401933.add
392: financials_system_parameters fsp