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 155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

151: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
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));

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 6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6016: WP.DEFAULT_PULL_SUPPLY_SUBINV,
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,

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 6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6098: W.DEFAULT_PULL_SUPPLY_SUBINV,
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,

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:

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

6581: csi.Unit_Of_measure UOM,
6582: UOM.unit_of_measure,
6583: P.DEFAULT_PULL_SUPPLY_SUBINV,
6584: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6585: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
6586: ||
6587: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
6588: ||
6589: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,

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

6583: P.DEFAULT_PULL_SUPPLY_SUBINV,
6584: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6585: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
6586: ||
6587: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
6588: ||
6589: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,
6590: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
6591: FROM

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

6585: inv_project.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id)|| '.'
6586: ||
6587: DECODE(D.segment19,NULL,NULL,inv_project.GET_PROJECT_NUMBER(D.segment19)) || '.'
6588: ||
6589: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,
6590: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
6591: FROM
6592: CSI_ITEM_INSTANCES CSI,
6593: MTL_SYSTEM_ITEMS_KFV I,

Line 6744: INV_PROJECT.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, V.ORGANIZATION_ID)

6740: C.UNIT_OF_MEASURE UOM,
6741: UOM.UNIT_OF_MEASURE,
6742: P.DEFAULT_PULL_SUPPLY_SUBINV,
6743: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6744: INV_PROJECT.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, V.ORGANIZATION_ID)
6745: || ''.''
6746: || DECODE(D.SEGMENT19,NULL,NULL, INV_PROJECT.GET_PROJECT_NUMBER(D.SEGMENT19))
6747: || ''.''
6748: || DECODE(D.SEGMENT20, NULL,NULL,INV_PROJECT.GET_TASK_NUMBER(D.SEGMENT20)) LOCATOR,

Line 6746: || DECODE(D.SEGMENT19,NULL,NULL, INV_PROJECT.GET_PROJECT_NUMBER(D.SEGMENT19))

6742: P.DEFAULT_PULL_SUPPLY_SUBINV,
6743: P.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6744: INV_PROJECT.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, V.ORGANIZATION_ID)
6745: || ''.''
6746: || DECODE(D.SEGMENT19,NULL,NULL, INV_PROJECT.GET_PROJECT_NUMBER(D.SEGMENT19))
6747: || ''.''
6748: || DECODE(D.SEGMENT20, NULL,NULL,INV_PROJECT.GET_TASK_NUMBER(D.SEGMENT20)) LOCATOR,
6749:
6750: V.INV_LOCATOR_ID,

Line 6748: || DECODE(D.SEGMENT20, NULL,NULL,INV_PROJECT.GET_TASK_NUMBER(D.SEGMENT20)) LOCATOR,

6744: INV_PROJECT.GET_LOCSEGS(P.DEFAULT_PULL_SUPPLY_LOCATOR_ID, V.ORGANIZATION_ID)
6745: || ''.''
6746: || DECODE(D.SEGMENT19,NULL,NULL, INV_PROJECT.GET_PROJECT_NUMBER(D.SEGMENT19))
6747: || ''.''
6748: || DECODE(D.SEGMENT20, NULL,NULL,INV_PROJECT.GET_TASK_NUMBER(D.SEGMENT20)) LOCATOR,
6749:
6750: V.INV_LOCATOR_ID,
6751: (select msn.current_status from mtl_serial_numbers msn where msn.inventory_item_id = C.INVENTORY_ITEM_ID and msn.serial_number = C.serial_number) serial_num_status
6752: FROM AHL_WORKORDERS W,