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 CSI_ITEM_INSTANCES

Line 864: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI

860: * Bug #4918991
861: */
862: /*
863: SELECT 'x'
864: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI
865: WHERE
866: DISP.INSTANCE_ID = CSI.INSTANCE_ID AND
867: DISP.WORKORDER_ID = WO.WORKORDER_ID AND
868: WO.WIP_ENTITY_ID = CSI.WIP_JOB_ID AND

Line 1979: FROM CSI_ITEM_INSTANCES CII

1975: p_job_id IN NUMBER,
1976: p_serial_num IN VARCHAR2) IS
1977: --p_wip_location NUMBER) IS (fix for bug# 5221513).
1978: SELECT INSTANCE_ID
1979: FROM CSI_ITEM_INSTANCES CII
1980: WHERE INVENTORY_ITEM_ID = p_item_id
1981: AND WIP_JOB_ID = p_job_id
1982: AND SERIAL_NUMBER = p_serial_num
1983: AND ACTIVE_START_DATE <= SYSDATE

Line 1999: FROM CSI_ITEM_INSTANCES CII

1995: --Query to validate the instance for the job during issue if there is a serial number avaialble
1996: CURSOR CSI_ISSUE_SER_ITEM_CUR(p_item_id IN NUMBER,
1997: p_serial_num IN VARCHAR2)IS
1998: SELECT INSTANCE_ID
1999: FROM CSI_ITEM_INSTANCES CII
2000: WHERE INVENTORY_ITEM_ID = p_item_id
2001: AND SERIAL_NUMBER = p_serial_num
2002: AND ACTIVE_START_DATE <= SYSDATE
2003: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))

Line 2836: l_sql := 'SELECT INSTANCE_ID, QUANTITY FROM CSI_ITEM_INSTANCES CII ';

2832: OR p_x_ahl_mtltxn_rec.Serial_Number = FND_API.G_MISS_CHAR) THEN
2833:
2834: -- Non serialized item:
2835:
2836: l_sql := 'SELECT INSTANCE_ID, QUANTITY FROM CSI_ITEM_INSTANCES CII ';
2837: l_sql := l_sql || ' WHERE 1=1';
2838: --l_sql := l_Sql || ' AND INV_MASTER_ORGANIZATION_ID=:b1';
2839: l_sql := l_sql || ' AND INVENTORY_ITEM_ID =:b2' ;
2840: l_sql := l_sql || ' AND WIP_JOB_ID=:b3';

Line 5078: FROM CSI_ITEM_INSTANCES CII

5074: p_lot_number IN VARCHAR2,
5075: p_Serial_Number IN VARCHAR2) IS
5076: /* fix for bug# 9268076
5077: SELECT 'x'
5078: FROM CSI_ITEM_INSTANCES CII
5079: WHERE CII.inventory_item_id = p_INVENTORY_ITEM_ID
5080: AND nvl(cii.inventory_revision,'1') = nvl(p_ITEM_Revision, '1')
5081: AND nvl(cii.lot_number, '1') = nvl(p_lot_number, '1')
5082: AND nvl(cii.serial_number,'1') = nvl(p_serial_number, '1')

Line 5101: FROM CSI_ITEM_INSTANCES CII

5097: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
5098: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
5099: AND NVL(CIR.ACTIVE_START_DATE,SYSDATE) <= SYSDATE
5100: AND (CIR.ACTIVE_END_DATE IS NULL OR CIR.ACTIVE_END_DATE > SYSDATE)) reln_exists
5101: FROM CSI_ITEM_INSTANCES CII
5102: WHERE CII.inventory_item_id = p_INVENTORY_ITEM_ID
5103: AND nvl(cii.inventory_revision,'1') = nvl(p_ITEM_Revision, '1')
5104: AND nvl(cii.lot_number, '1') = nvl(p_lot_number, '1')
5105: AND nvl(cii.serial_number,'1') = nvl(p_serial_number, '1')

Line 5133: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,

5129: organization_id AHL_VISITS_B.ORGANIZATION_ID%TYPE,
5130: workorder_operation_id AHL_PRD_DISPOSITIONS_B.WO_OPERATION_ID%TYPE,
5131: operation_sequence_num AHL_WORKORDER_OPERATIONS.OPERATION_SEQUENCE_NUM%TYPE,
5132: item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
5133: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
5134: item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE,
5135: immediate_disposition_code AHL_PRD_DISPOSITIONS_B.IMMEDIATE_DISPOSITION_CODE%TYPE,
5136: disposition_id AHL_PRD_DISPOSITIONS_B.DISPOSITION_ID%TYPE,
5137: immediate_type FND_LOOKUP_VALUES.MEANING%TYPE,

Line 5140: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,

5136: disposition_id AHL_PRD_DISPOSITIONS_B.DISPOSITION_ID%TYPE,
5137: immediate_type FND_LOOKUP_VALUES.MEANING%TYPE,
5138: condition_code MTL_MATERIAL_STATUSES_TL.STATUS_CODE%TYPE,
5139: condition_id AHL_PRD_DISPOSITIONS_B.CONDITION_ID%TYPE,
5140: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
5141: uom AHL_PRD_DISPOSITIONS_B.UOM%TYPE,
5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
5143: job_status_meaning FND_LOOKUP_VALUES.MEANING%TYPE,
5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,

Line 5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,

5140: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
5141: uom AHL_PRD_DISPOSITIONS_B.UOM%TYPE,
5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
5143: job_status_meaning FND_LOOKUP_VALUES.MEANING%TYPE,
5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
5146: collection_id AHL_PRD_DISPOSITIONS_B.COLLECTION_ID%TYPE,
5147: instance_id AHL_PRD_DISPOSITIONS_B.INSTANCE_ID%TYPE,
5148: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,

Line 5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,

5141: uom AHL_PRD_DISPOSITIONS_B.UOM%TYPE,
5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
5143: job_status_meaning FND_LOOKUP_VALUES.MEANING%TYPE,
5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
5146: collection_id AHL_PRD_DISPOSITIONS_B.COLLECTION_ID%TYPE,
5147: instance_id AHL_PRD_DISPOSITIONS_B.INSTANCE_ID%TYPE,
5148: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
5149: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,

Line 5148: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,

5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
5146: collection_id AHL_PRD_DISPOSITIONS_B.COLLECTION_ID%TYPE,
5147: instance_id AHL_PRD_DISPOSITIONS_B.INSTANCE_ID%TYPE,
5148: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
5149: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
5151: concatenated_segments MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE,
5152: quantity AHL_PRD_DISPOSITIONS_B.QUANTITY%TYPE,

Line 5153: net_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,

5149: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
5151: concatenated_segments MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE,
5152: quantity AHL_PRD_DISPOSITIONS_B.QUANTITY%TYPE,
5153: net_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
5154: Wo_Net_Total_Qty NUMBER,
5155: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
5156: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE,
5157: --JKJain, Bug 9268076

Line 5182: l_instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE;

5178: l_cnt_disposition NUMBER;
5179: l_pend_count NUMBER;
5180:
5181: --pdoki added for Bug 12564439; sorao backporting project
5182: l_instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE;
5183:
5184: -- check serial current status.
5185: CURSOR mtl_serial_csr (p_inv_item_id IN NUMBER,
5186: p_serial_num IN VARCHAR2)

Line 5262: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = D.INSTANCE_ID) instance_number,

5258: D.LOT_NUMBER,
5259: D.ITEM_REVISION,
5260: D.COLLECTION_ID,
5261: D.INSTANCE_ID,
5262: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = D.INSTANCE_ID) instance_number,
5263: WP.DEFAULT_PULL_SUPPLY_SUBINV,
5264: WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
5265: L.CONCATENATED_SEGMENTS,
5266: --SYSDATE,

Line 5407: FROM CSI_ITEM_INSTANCES

5403:
5404: IF l_disp_rec.instance_id IS NOT NULL THEN
5405: SELECT instance_number
5406: INTO l_instance_number
5407: FROM CSI_ITEM_INSTANCES
5408: WHERE instance_id = l_disp_rec.instance_id ;
5409: END IF;
5410:
5411: -- added to support duplicate dispositions for the same item/lot/revision in same wo.

Line 6025: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = TXNS.INSTANCE_ID) instance_number

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
6027: AHL_WORKORDER_MTL_TXNS TXNS,
6028: AHL_WORKORDERS WO,
6029: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,

Line 6107: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = A.INSTANCE_ID) instance_number

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:
6109:
6110: FROM
6111: AHL_WORKORDER_MTL_TXNS A,

Line 6156: FROM CSI_ITEM_INSTANCES CII

6152: -- and is located in the wip job.
6153: CURSOR chk_inst_relationship_csr (p_instance_id IN NUMBER,
6154: p_wip_entity_id IN NUMBER) IS
6155: SELECT 'x'
6156: FROM CSI_ITEM_INSTANCES CII
6157: WHERE CII.INSTANCE_ID = p_instance_id
6158: AND CII.ACTIVE_START_DATE <= SYSDATE
6159: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
6160: AND CII.QUANTITY > 0

Line 6592: CSI_ITEM_INSTANCES CSI,

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,
6594: AHL_SEARCH_WORKORDERS_v W,
6595: WIP_PARAMETERS P,
6596: MTL_UNITS_OF_MEASURE_VL UOM,

Line 6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,

6689: job_number AHL_WORKORDERS.WORKORDER_NAME%TYPE,
6690: job_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE,
6691: description MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE,
6692: organization_id AHL_VISITS_B.ORGANIZATION_ID%TYPE,
6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,

Line 6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,

6691: description MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE,
6692: organization_id AHL_VISITS_B.ORGANIZATION_ID%TYPE,
6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,

Line 6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,

6692: organization_id AHL_VISITS_B.ORGANIZATION_ID%TYPE,
6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,

Line 6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,

6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,

Line 6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,

6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,
6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,

Line 6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,

6695: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
6696: instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE,
6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,
6703: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,

Line 6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,

6697: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,
6703: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
6704: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
6705: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,

Line 6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,

6698: revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,
6703: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
6704: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
6705: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
6706: locator VARCHAR2(500),

Line 6756: CSI_ITEM_INSTANCES C,

6752: FROM AHL_WORKORDERS W,
6753: FND_LOOKUP_VALUES_VL MLU,
6754: MTL_SYSTEM_ITEMS_KFV I,
6755: AHL_VISITS_B V,
6756: CSI_ITEM_INSTANCES C,
6757: MTL_UNITS_OF_MEASURE_VL UOM,
6758: WIP_PARAMETERS P,
6759: MTL_ITEM_LOCATIONS D ';
6760: