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.AHL_PRD_MTLTXN_PVT dependencies on INV_PROJECTLOCATOR_PUB

Line 156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

152: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
153: AND MIL.ORGANIZATION_ID = p_org_Id
154: AND decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
157: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) = p_location_name
158: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
159: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
160:

Line 157: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) = p_location_name

153: AND MIL.ORGANIZATION_ID = p_org_Id
154: AND decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
157: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) = p_location_name
158: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
159: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
160:
161: l_locator_segments VARCHAR2(240);

Line 6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6017: WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6018: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
6019: --Fix for bug number 5903275
6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6022: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
6023: --SYSDATE
6024: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id,
6025: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = TXNS.INSTANCE_ID) instance_number

Line 6022: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,

6018: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
6019: --Fix for bug number 5903275
6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6022: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
6023: --SYSDATE
6024: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id,
6025: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = TXNS.INSTANCE_ID) instance_number
6026: FROM

Line 6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6099: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6100: --D.CONCATENATED_SEGMENTS Locator
6101: -- Fix for bug number 5903275
6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6104: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
6105: --SYSDATE
6106: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id,
6107: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = A.INSTANCE_ID) instance_number

Line 6104: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,

6100: --D.CONCATENATED_SEGMENTS Locator
6101: -- Fix for bug number 5903275
6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6104: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
6105: --SYSDATE
6106: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id,
6107: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = A.INSTANCE_ID) instance_number
6108: