APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_WORKORDER_MTL_TXNS_S

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 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,