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_MTL_TXNS

Line 1343: --Insert a record into the AHL_WORKORDER_MTL_TXNS.

1339: --IF( l_x_sr_rec_tbl.COUNT > 0) THEN
1340: -- l_nonrtn_wo_id := l_x_sr_rec_tbl(i).Nonroutine_wo_id;
1341: --END IF;
1342:
1343: --Insert a record into the AHL_WORKORDER_MTL_TXNS.
1344: IF(p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id = FND_API.G_MISS_NUM OR
1345: p_x_ahl_mtltxn_tbl(i).disposition_id is NOT NULL) THEN
1346: p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id := NULL;
1347: END IF;

Line 1356: -- In case of dynamic locator creation, retrieve locator ID to populate ahl_workorder_mtl_txns table.

1352: IF(p_x_ahl_mtltxn_tbl(i).Locator_Id = FND_API.G_MISS_NUM) THEN
1353: p_x_ahl_mtltxn_tbl(i).Locator_Id := NULL;
1354: END IF;
1355:
1356: -- In case of dynamic locator creation, retrieve locator ID to populate ahl_workorder_mtl_txns table.
1357: IF (p_x_ahl_mtltxn_tbl(i).locator_segments IS NOT NULL AND
1358: p_x_ahl_mtltxn_tbl(i).locator_id IS NULL) THEN
1359:
1360: IF G_DEBUG='Y' THEN

Line 1693: UPDATE AHL_WORKORDER_MTL_TXNS

1689: AHL_DEBUG_PUB.debug('l_sr_mtl_id_map_tbl[' || j || ']=['|| l_sr_mtl_id_map_tbl(j) ||']');
1690: END IF;
1691:
1692: -- update non-routine workorder id.
1693: UPDATE AHL_WORKORDER_MTL_TXNS
1694: SET NON_ROUTINE_WORKORDER_ID = l_x_sr_rec_tbl(j).Nonroutine_wo_id,
1695: -- Adithya added for bug# 6995541
1696: CS_INCIDENT_ID = l_x_sr_rec_tbl(j).Incident_id
1697: WHERE WORKORDER_MTL_TXN_ID = l_sr_mtl_id_map_tbl(j);

Line 1814: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(

1810: AHL_DEBUG_PUB.enable_debug;
1811: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Inventory_Item_Id='|| p_x_ahl_mtltxn_rec.Inventory_Item_Id);
1812: AHL_DEBUG_PUB.debug('Entered Insert_Mtl_Txn_Row, p_x_ahl_mtltxn_rec.Recepient_id='||p_x_ahl_mtltxn_rec.Recepient_id);
1813: END IF;
1814: AHL_WORKORDER_MTL_TXNS_PKG.INSERT_ROW(
1815: X_ROWID => l_x_row_id,
1816: X_WORKORDER_MTL_TXN_ID => x_ahl_mtl_txn_id,
1817: X_OBJECT_VERSION_NUMBER => 1,
1818: X_WORKORDER_OPERATION_ID => p_x_ahl_mtltxn_rec.workorder_Operation_Id,

Line 1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;

1855: X_LAST_UPDATE_DATE => SYSDATE,
1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1858:
1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1860: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1861:
1862: IF G_DEBUG='Y' THEN
1863: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);

Line 1899: FROM AHL_WORKORDER_MTL_TXNS A,

1895: C_WO_MTLTXN_ID IN NUMBER
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

Line 4618: FROM AHL_WORKORDER_MTL_TXNS

4614: -- The following line will be needed in the case net quantity issued is to be displayed, instead of entire issued quantity
4615: -- SELECT sum(nvl(decode(TRANSACTION_TYPE_ID, 35, QUANTITY, 43, -QUANTITY, 0), 0))
4616: SELECT sum(nvl(QUANTITY, 0))
4617: INTO l_iss_qty
4618: FROM AHL_WORKORDER_MTL_TXNS
4619: WHERE ORGANIZATION_ID = P_ORG_ID
4620: AND INVENTORY_ITEM_ID = P_ITEM_ID
4621: AND WORKORDER_OPERATION_ID = P_WORKORDER_OP_ID
4622: -- The following line will NOT be needed in the case net quantity issued is to be displayed

Line 4643: FROM AHL_WORKORDER_MTL_TXNS A

4639: As
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'))

Line 4692: FROM AHL_WORKORDER_MTL_TXNS A ,

4688: -- cursor for getting total issued quantity
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

Line 4707: FROM AHL_WORKORDER_MTL_TXNS A ,

4703: -- cursor for getting total returned quantity
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

Line 4918: AHL_WORKORDER_MTL_TXNS a,

4914:
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

Line 4933: AHL_WORKORDER_MTL_TXNS a,

4929: AND a.workorder_operation_id=nvl(p_wo_op_id, a.workorder_operation_id);
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

Line 5917: AHL_WORKORDER_MTL_TXNS T,

5913: T.INSTANCE_ID, -- added to fix FP bug# 5172147.
5914: W.WIP_ENTITY_ID, -- added to filter chk_inst_relationship_csr for wip_job_id.
5915: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5916: FROM
5917: AHL_WORKORDER_MTL_TXNS T,
5918: MTL_SYSTEM_ITEMS_KFV I,
5919: AHL_WORKORDERS W,
5920: AHL_VISITS_B V,
5921: AHL_VISIT_TASKS_B VT,

Line 6027: AHL_WORKORDER_MTL_TXNS TXNS,

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,
6030: AHL_VISIT_TASKS_B VST_TASK,
6031: AHL_VISITS_B VST,

Line 6111: AHL_WORKORDER_MTL_TXNS A,

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,
6112: MTL_SYSTEM_ITEMS_KFV B,
6113: MTL_UNITS_OF_MEASURE_VL UOM,
6114: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6115: --MTL_ITEM_LOCATIONS_KFV D,

Line 6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,

6180: l_mtl_txn_dtls_where VARCHAR2(10000);
6181:
6182: TYPE l_mtlTxn_rec_type IS RECORD (
6183: workorder_id AHL_WORKORDERS.WORKORDER_ID%TYPE,
6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,
6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,

Line 6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,

6181:
6182: TYPE l_mtlTxn_rec_type IS RECORD (
6183: workorder_id AHL_WORKORDERS.WORKORDER_ID%TYPE,
6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,
6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,
6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,

Line 6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,

6182: TYPE l_mtlTxn_rec_type IS RECORD (
6183: workorder_id AHL_WORKORDERS.WORKORDER_ID%TYPE,
6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,
6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,
6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,
6190: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,

Line 6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,

6183: workorder_id AHL_WORKORDERS.WORKORDER_ID%TYPE,
6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,
6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,
6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,
6190: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6191: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE

Line 6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,

6184: organization_id AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID%TYPE,
6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,
6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,
6190: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6191: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE
6192: );

Line 6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,

6185: inventory_item_id AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID%TYPE,
6186: serial_number AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER%TYPE,
6187: lot_number AHL_WORKORDER_MTL_TXNS.LOT_NUMBER%TYPE,
6188: revision AHL_WORKORDER_MTL_TXNS.REVISION%TYPE,
6189: instance_id AHL_WORKORDER_MTL_TXNS.INSTANCE_ID%TYPE,
6190: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6191: inv_locator_id AHL_VISITS_B.INV_LOCATOR_ID%TYPE
6192: );
6193: l_mtlTxn_rec l_mtlTxn_rec_type;

Line 6218: AHL_WORKORDER_MTL_TXNS T,

6214: T.INSTANCE_ID,
6215: W.WIP_ENTITY_ID,
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:

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