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 WIP_PARAMETERS

Line 2140: FROM wip_parameters

2136:
2137: -- Default Subinventory.
2138: CURSOR wip_params_cur (p_org_id IN NUMBER) IS
2139: SELECT default_pull_supply_subinv, default_pull_supply_locator_id
2140: FROM wip_parameters
2141: WHERE organization_id = p_org_id;
2142:
2143: CURSOR workorder_released_date_csr(p_wip_entity_id IN NUMBER) IS
2144: SELECT DATE_RELEASED FROM WIP_DISCRETE_JOBS

Line 2210: l_def_supply_subinv wip_parameters.default_pull_supply_subinv%TYPE;

2206: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
2207: l_quantity NUMBER;
2208: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
2209: l_visit_id NUMBER;
2210: l_def_supply_subinv wip_parameters.default_pull_supply_subinv%TYPE;
2211: l_def_supply_locator_id NUMBER;
2212:
2213: L_SCHED_START_DATE DATE;
2214:

Line 5041: WIP_PARAMETERS WIP,

5037: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
5038: BOM_DEPARTMENTS B,
5039: AHL_WORKORDER_OPERATIONS O,
5040: MTL_UNITS_OF_MEASURE_VL UOM,
5041: WIP_PARAMETERS WIP,
5042: MTL_ITEM_LOCATIONS_KFV L
5043: WHERE
5044: D.WORKORDER_ID = W.WORKORDER_ID AND
5045: W.MASTER_WORKORDER_FLAG = 'N' AND

Line 5149: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%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,
5153: net_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,

Line 5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%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,
5153: net_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
5154: Wo_Net_Total_Qty NUMBER,

Line 5279: WIP_PARAMETERS WP,

5275: AHL_VISITS_B V,
5276: AHL_WORKORDER_OPERATIONS O,
5277: MTL_UNITS_OF_MEASURE_VL UOM,
5278: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND LANGUAGE= USERENV(''LANG'')) WO_STS,
5279: WIP_PARAMETERS WP,
5280: MTL_ITEM_LOCATIONS_KFV L,
5281: AHL_WORKORDERS W ';
5282:
5283:

Line 6038: WIP_PARAMETERS WP,

6034: MTL_UNITS_OF_MEASURE_VL UOM,
6035: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6036: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
6037: MTL_ITEM_LOCATIONS MTL_LOC,
6038: WIP_PARAMETERS WP,
6039: PER_ALL_PEOPLE_F PER
6040: WHERE
6041: TXNS.TRANSACTION_TYPE_ID = 35 AND
6042: TXNS.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND

Line 6122: WIP_PARAMETERS W

6118: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
6119: AHL_VISITS_B V,
6120: AHL_VISIT_TASKS_B VT,
6121: AHL_WORKORDER_OPERATIONS F,
6122: WIP_PARAMETERS W
6123: WHERE
6124: A.INVENTORY_ITEM_ID=B.INVENTORY_ITEM_ID
6125: AND A.WORKORDER_OPERATION_ID=F.WORKORDER_OPERATION_ID
6126: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID

Line 6595: WIP_PARAMETERS P,

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,
6597: MTL_ITEM_LOCATIONS D,
6598: MTL_PARAMETERS MP
6599: WHERE

Line 6704: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%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),
6707:
6708: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE,

Line 6705: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_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),
6707:
6708: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE,
6709: SERIAL_NUM_STATUS mtl_serial_numbers.current_status%TYPE );

Line 6758: WIP_PARAMETERS P,

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:
6761:
6762: l_mtl_txn_dtls_where := '