eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_LINE_LOCATIONS

Line 262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;

258: -- Declare TABLEs for each column that is selected
259: -- from po_line_csr and po_line_loc_csr.
260: --
261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;

Line 272: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%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;
275:
276: l_line_num_tbl line_num_tbl_type;

Line 273: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%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;
275:
276: l_line_num_tbl line_num_tbl_type;
277: l_shipment_num_tbl shipment_num_tbl_type;

Line 274: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%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;
275:
276: l_line_num_tbl line_num_tbl_type;
277: l_shipment_num_tbl shipment_num_tbl_type;
278: l_item_num_tbl item_num_tbl_type;

Line 386: po_line_locations pll,

382: --Bug 4950850 Added pll.amount
383: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
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,