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 AHL_PRD_DISPOSITIONS_B

Line 234: FROM AHL_PRD_DISPOSITIONS_B A

230: * R12 Drop 4 - SQL ID: 14399309
231: * Bug #4918991
232: */
233: SELECT DISPOSITION_ID
234: FROM AHL_PRD_DISPOSITIONS_B A
235: WHERE
236: A.WORKORDER_ID = C_WORKORDER_ID AND
237: A.DISPOSITION_ID = C_DISP_ID;
238:

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 5127: workorder_id AHL_PRD_DISPOSITIONS_B.WORKORDER_ID%TYPE,

5123: l_mtl_txn_dtls VARCHAR2(10000);
5124: l_mtl_txn_dtls_where VARCHAR2(10000);
5125:
5126: TYPE l_disp_rec_type IS RECORD (
5127: workorder_id AHL_PRD_DISPOSITIONS_B.WORKORDER_ID%TYPE,
5128: workorder_name AHL_WORKORDERS.WORKORDER_NAME%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,

Line 5130: workorder_operation_id AHL_PRD_DISPOSITIONS_B.WO_OPERATION_ID%TYPE,

5126: TYPE l_disp_rec_type IS RECORD (
5127: workorder_id AHL_PRD_DISPOSITIONS_B.WORKORDER_ID%TYPE,
5128: workorder_name AHL_WORKORDERS.WORKORDER_NAME%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,

Line 5135: immediate_disposition_code AHL_PRD_DISPOSITIONS_B.IMMEDIATE_DISPOSITION_CODE%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,
5138: condition_code MTL_MATERIAL_STATUSES_TL.STATUS_CODE%TYPE,
5139: condition_id AHL_PRD_DISPOSITIONS_B.CONDITION_ID%TYPE,

Line 5136: disposition_id AHL_PRD_DISPOSITIONS_B.DISPOSITION_ID%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,
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,

Line 5139: condition_id AHL_PRD_DISPOSITIONS_B.CONDITION_ID%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,
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,

Line 5141: uom AHL_PRD_DISPOSITIONS_B.UOM%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,
5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,

Line 5146: collection_id AHL_PRD_DISPOSITIONS_B.COLLECTION_ID%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,
5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,

Line 5147: instance_id AHL_PRD_DISPOSITIONS_B.INSTANCE_ID%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,
5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
5151: concatenated_segments MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE,

Line 5152: quantity AHL_PRD_DISPOSITIONS_B.QUANTITY%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,
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,

Line 5158: path_position_id AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID%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
5158: path_position_id AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID%TYPE
5159: );
5160:
5161: l_disp_rec l_disp_rec_type;
5162: