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 343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;

339: -- Declare TABLEs for each column that is selected
340: -- from po_line_csr and po_line_loc_csr.
341: --
342: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;

Line 353: TYPE need_by_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.need_by_date%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;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;

Line 354: TYPE promised_date_tbl_type IS TABLE OF PO_LINE_LOCATIONS.promised_date%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;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;

Line 355: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%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;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;
359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;

Line 534: po_line_locations_all pll, -- CLM apprvl

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