DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on HR_LOCATIONS

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

347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
351: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
352: TYPE organization_name_tbl_type IS TABLE OF ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
353: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%TYPE;
354: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%TYPE;
355: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%TYPE;

Line 536: hr_locations_all hrl,

532: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
533: FROM po_lines_all pol, -- CLM apprvl
534: po_line_locations_all pll, -- CLM apprvl
535: mtl_system_items_kfv msi,
536: hr_locations_all hrl,
537: hz_locations hz,
538: org_organization_definitions ood,
539: mtl_units_of_measure muom, -- Bug 2401933.add
540: financials_system_parameters fsp