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_WORKORDER_OPERATIONS

Line 201: FROM AHL_WORKORDER_OPERATIONS

197: AND C.VISIT_ID = B.VISIT_ID;
198: -- Cursor for Work order operation id.
199: CURSOR WO_OP_CUR(p_wo_id NUMBER, p_oper_seq NUMBER) IS
200: SELECT WORKORDER_OPERATION_ID
201: FROM AHL_WORKORDER_OPERATIONS
202: WHERE WORKORDER_ID = p_wo_id
203: AND OPERATION_SEQUENCE_NUM = p_oper_seq;
204: -- query for converting condition desc
205: CURSOR CONDITION_CUR (p_condition_desc VARCHAR2) IS

Line 1900: AHL_WORKORDER_OPERATIONS_V B,

1896: )
1897: IS
1898: SELECT COUNT(A.workorder_mtl_txn_id)
1899: FROM AHL_WORKORDER_MTL_TXNS A,
1900: AHL_WORKORDER_OPERATIONS_V B,
1901: AHL_SCHEDULE_MATERIALS C
1902: WHERE B.WORKORDER_ID=C_WRK_ID
1903: AND B.WORKORDER_OPERATION_ID=A.WORKORDER_OPERATION_ID
1904: AND B.WORKORDER_OPERATION_ID=C.WORKORDER_OPERATION_ID

Line 2012: FROM AHL_WORKORDER_OPERATIONS

2008:
2009: --Query to validate workorder operaiton id.
2010: CURSOR AHL_WORKORDER_OPER_CUR (p_wo_id NUMBER,p_op_seq NUMBER, p_woop_id IN NUMBER) IS
2011: SELECT 1
2012: FROM AHL_WORKORDER_OPERATIONS
2013: WHERE WORKORDER_OPERATION_ID =p_woop_id
2014: AND WORKORDER_ID =p_wo_id
2015: AND OPERATION_SEQUENCE_NUM = p_op_seq;
2016:

Line 2119: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B

2115:
2116: /*
2117: CURSOR TRANSACTION_DATE_CUR(C_WORKORDER_OPERATION_ID NUMBER,C_WORKORDER_ID NUMBER,C_INV_ITEM_ID NUMBER) IS
2118: SELECT A.scheduled_start_date
2119: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B
2120: WHERE A.WORKORDER_OPERATION_ID=C_WORKORDER_OPERATION_ID
2121: AND A.WORKORDER_ID=C_WORKORDER_ID
2122: AND A.WORKORDER_OPERATION_ID=B.WORKORDER_OPERATION_ID
2123: AND B.INVENTORY_ITEM_ID=C_INV_ITEM_ID

Line 4644: ,AHL_WORKORDER_OPERATIONS_V B

4640: issued NUMBER;
4641: CURSOR CUR_GET_WOID_LEVEL_QTY IS
4642: SELECT SUM(nvl(QUANTITY,0))
4643: FROM AHL_WORKORDER_MTL_TXNS A
4644: ,AHL_WORKORDER_OPERATIONS_V B
4645: WHERE A.ORGANIZATION_ID = p_org_id
4646: AND A.INVENTORY_ITEM_ID = p_item_id
4647: AND NVL(A.lot_number,'X')=NVL(p_lotnum,NVL(A.lot_number,'X'))
4648: AND NVL(A.revision,'X')=NVL(p_rev,NVL(A.REVISION,'X'))

Line 4693: -- AHL_WORKORDER_OPERATIONS_V B

4689: CURSOR CUR_GET_WO_ISSUE_QTY
4690: IS
4691: SELECT SUM(nvl(QUANTITY,0))
4692: FROM AHL_WORKORDER_MTL_TXNS A ,
4693: -- AHL_WORKORDER_OPERATIONS_V B
4694: -- JKJAIN BUG # 7587902
4695: AHL_WORKORDER_OPERATIONS B
4696: WHERE A.ORGANIZATION_ID = p_org_id
4697: AND A.INVENTORY_ITEM_ID = p_item_id

Line 4695: AHL_WORKORDER_OPERATIONS B

4691: SELECT SUM(nvl(QUANTITY,0))
4692: FROM AHL_WORKORDER_MTL_TXNS A ,
4693: -- AHL_WORKORDER_OPERATIONS_V B
4694: -- JKJAIN BUG # 7587902
4695: AHL_WORKORDER_OPERATIONS B
4696: WHERE A.ORGANIZATION_ID = p_org_id
4697: AND A.INVENTORY_ITEM_ID = p_item_id
4698: AND A.TRANSACTION_TYPE_ID =35
4699: -- AND A.ORGANIZATION_ID = B.organization_id

Line 4708: -- AHL_WORKORDER_OPERATIONS_V B

4704: CURSOR CUR_GET_WO_RET_QTY
4705: IS
4706: SELECT SUM(nvl(QUANTITY,0))
4707: FROM AHL_WORKORDER_MTL_TXNS A ,
4708: -- AHL_WORKORDER_OPERATIONS_V B
4709: -- JKJAIN BUG # 7587902
4710: AHL_WORKORDER_OPERATIONS B
4711: WHERE A.ORGANIZATION_ID = p_org_id
4712: AND A.INVENTORY_ITEM_ID = p_item_id

Line 4710: AHL_WORKORDER_OPERATIONS B

4706: SELECT SUM(nvl(QUANTITY,0))
4707: FROM AHL_WORKORDER_MTL_TXNS A ,
4708: -- AHL_WORKORDER_OPERATIONS_V B
4709: -- JKJAIN BUG # 7587902
4710: AHL_WORKORDER_OPERATIONS B
4711: WHERE A.ORGANIZATION_ID = p_org_id
4712: AND A.INVENTORY_ITEM_ID = p_item_id
4713: AND A.TRANSACTION_TYPE_ID =43
4714: -- AND A.ORGANIZATION_ID = B.organization_id

Line 4919: AHL_WORKORDER_OPERATIONS b

4915:
4916: SELECT SUM(NVL(a.primary_uom_qty,0)) INTO l_iss_qty
4917: FROM
4918: AHL_WORKORDER_MTL_TXNS a,
4919: AHL_WORKORDER_OPERATIONS b
4920: WHERE
4921: a.workorder_operation_id=b.workorder_operation_id
4922: AND a.transaction_type_id=35
4923: AND b.workorder_id=p_wo_id

Line 4934: AHL_WORKORDER_OPERATIONS b

4930:
4931: SELECT SUM(NVL(a.primary_uom_qty,0)) INTO l_rtn_qty
4932: FROM
4933: AHL_WORKORDER_MTL_TXNS a,
4934: AHL_WORKORDER_OPERATIONS b
4935: WHERE
4936: a.workorder_operation_id=b.workorder_operation_id
4937: AND a.transaction_type_id=43
4938: AND b.workorder_id=p_wo_id

Line 5039: AHL_WORKORDER_OPERATIONS O,

5035: CS_INCIDENTS_ALL_B C,
5036: WIP_DISCRETE_JOBS WDJ,
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

Line 5131: operation_sequence_num AHL_WORKORDER_OPERATIONS.OPERATION_SEQUENCE_NUM%TYPE,

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,
5135: immediate_disposition_code AHL_PRD_DISPOSITIONS_B.IMMEDIATE_DISPOSITION_CODE%TYPE,

Line 5276: AHL_WORKORDER_OPERATIONS O,

5272: D.PATH_POSITION_ID
5273: FROM
5274: AHL_MTL_RET_DISPOSITIONS_V D,
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,

Line 5926: AHL_WORKORDER_OPERATIONS O

5922: CS_INCIDENTS_ALL_B C,
5923: WIP_DISCRETE_JOBS WDJ,
5924: INV_ORGANIZATION_NAME_V ORG,
5925: BOM_DEPARTMENTS B,
5926: AHL_WORKORDER_OPERATIONS O
5927: WHERE
5928: T.ORGANIZATION_ID = V.ORGANIZATION_ID
5929: AND T.WORKORDER_OPERATION_ID = O.WORKORDER_OPERATION_ID
5930: AND W.WORKORDER_ID = O.WORKORDER_ID

Line 6032: AHL_WORKORDER_OPERATIONS WO_OP,

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,
6030: AHL_VISIT_TASKS_B VST_TASK,
6031: AHL_VISITS_B VST,
6032: AHL_WORKORDER_OPERATIONS WO_OP,
6033: MTL_SYSTEM_ITEMS_KFV MTL,
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,

Line 6121: AHL_WORKORDER_OPERATIONS F,

6117: AHL_WORKORDERS E,
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

Line 6220: AHL_WORKORDER_OPERATIONS O,

6216: V.INV_LOCATOR_ID
6217: FROM
6218: AHL_WORKORDER_MTL_TXNS T,
6219: AHL_WORKORDERS W,
6220: AHL_WORKORDER_OPERATIONS O,
6221: AHL_VISITS_B V ' ;
6222:
6223: l_mtl_txn_dtls_where := '
6224: WHERE T.TRANSACTION_TYPE_ID = 35

Line 6630: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o

6626: AND NVL(ACTIVE_END_DATE,SYSDATE))
6627: /* fix for bug# 6310766: extra row being displayed with 0 qty
6628: -- split this query into two to handle serialized and non-serialized items.
6629: AND NOT EXISTS (SELECT 'x'
6630: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o
6631: where txn.workorder_operation_id = o.workorder_operation_id
6632: and o.workorder_id = w.workorder_id
6633: and txn.instance_id = csi.instance_id
6634: and txn.TRANSACTION_TYPE_ID = 35)

Line 6638: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o

6634: and txn.TRANSACTION_TYPE_ID = 35)
6635: */
6636: -- for non-serialized items
6637: /* AND NOT EXISTS (SELECT 'x'
6638: from ahl_workorder_mtl_txns txn, AHL_WORKORDER_OPERATIONS o
6639: where txn.workorder_operation_id = o.workorder_operation_id
6640: and o.workorder_id = w.workorder_id
6641: and txn.TRANSACTION_TYPE_ID = 35
6642: and txn.serial_number is null