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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_HEADERS_VL

Line 25: TITLE AHL_MR_HEADERS_VL.TITLE%TYPE,

21: -- To hold the applicable MRs table record.
22: TYPE applicable_mrs_rec_type IS RECORD(
23: CSI_ITEM_INSTANCE_ID NUMBER,
24: MR_HEADER_ID NUMBER,
25: TITLE AHL_MR_HEADERS_VL.TITLE%TYPE,
26: VERSION_NUMBER NUMBER,
27: REPETITIVE_FLAG VARCHAR2(1),
28: SHOW_REPETITIVE_CODE VARCHAR2(30),
29: IMPLEMENT_STATUS_CODE VARCHAR2(30),

Line 2085: --FROM ahl_applicable_MRs appl, ahl_mr_headers_vl mr

2081: appl.descendent_count,
2082: mr.whichever_first_code,
2083: mr.effective_to,
2084: mr.effective_from
2085: --FROM ahl_applicable_MRs appl, ahl_mr_headers_vl mr
2086: FROM ahl_applicable_MRs appl, ahl_mr_headers_b mr
2087: WHERE appl.csi_item_instance_id = p_csi_item_instance_id
2088: AND (appl.implement_status_code <> 'OPTIONAL_DO_NOT_IMPLEMENT')
2089: AND appl.preceding_mr_header_id IS NULL