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_PROJECT

Line 144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

140: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
141: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
145: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
146: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = upper(p_location_name)
147: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
148: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));

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

141: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
145: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
146: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = upper(p_location_name)
147: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
148: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
149:

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

142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
145: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
146: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = upper(p_location_name)
147: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
148: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
149:
150: l_locator_segments VARCHAR2(240);

Line 4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

4662: WIP.DEFAULT_PULL_SUPPLY_SUBINV,
4663: WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4664: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
4665: --Fix for bug number 5903275
4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4667: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4668: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id

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

4663: WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4664: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
4665: --Fix for bug number 5903275
4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4667: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4668: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id
4671: FROM

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

4664: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
4665: --Fix for bug number 5903275
4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4667: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4668: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id
4671: FROM
4672: AHL_WORKORDER_MTL_TXNS TXNS,

Line 4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

4742: W.DEFAULT_PULL_SUPPLY_SUBINV,
4743: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4744: --D.CONCATENATED_SEGMENTS Locator
4745: -- Fix for bug number 5903275
4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4747: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4748: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id

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

4743: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4744: --D.CONCATENATED_SEGMENTS Locator
4745: -- Fix for bug number 5903275
4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4747: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4748: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id
4751: FROM

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

4744: --D.CONCATENATED_SEGMENTS Locator
4745: -- Fix for bug number 5903275
4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4747: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4748: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id
4751: FROM
4752: AHL_WORKORDER_MTL_TXNS A,

Line 5074: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'

5070: csi.Unit_Of_measure UOM,
5071: UOM.unit_of_measure,
5072: P.DEFAULT_PULL_SUPPLY_SUBINV,
5073: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
5074: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
5075: ||
5076: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
5077: ||
5078: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,

Line 5076: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'

5072: P.DEFAULT_PULL_SUPPLY_SUBINV,
5073: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
5074: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
5075: ||
5076: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
5077: ||
5078: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,
5079: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5080: FROM

Line 5078: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,

5074: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
5075: ||
5076: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
5077: ||
5078: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,
5079: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5080: FROM
5081: CSI_ITEM_INSTANCES CSI,
5082: MTL_SYSTEM_ITEMS_KFV I,