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.WIP_MOVPROC_PRIV dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 956: * and WIP_MOVE_TXN_ALLOCATIONS

952:
953: /*****************************************************************************
954: * This procedure is equivalent to witoc_insert_alloc_child in wiltps.ppc
955: * This procedure is used to insert child record into WIP_MOVE_TXN_INTERFACE
956: * and WIP_MOVE_TXN_ALLOCATIONS
957: ****************************************************************************/
958: PROCEDURE insert_alloc_child(p_org_id IN NUMBER,
959: p_scheID IN NUMBER,
960: p_oc_pri_qty IN NUMBER,

Line 1030: -- to wip_move_txn_allocations as well

1026: END IF;
1027:
1028: IF(p_scheID > 0) THEN
1029: -- this is a repetitvie schedule, hence must insert allocation records
1030: -- to wip_move_txn_allocations as well
1031: INSERT INTO wip_move_txn_allocations
1032: (transaction_id,
1033: repetitive_schedule_id,
1034: organization_id,

Line 1031: INSERT INTO wip_move_txn_allocations

1027:
1028: IF(p_scheID > 0) THEN
1029: -- this is a repetitvie schedule, hence must insert allocation records
1030: -- to wip_move_txn_allocations as well
1031: INSERT INTO wip_move_txn_allocations
1032: (transaction_id,
1033: repetitive_schedule_id,
1034: organization_id,
1035: last_update_date,

Line 1060: FROM wip_move_txn_allocations wmta

1056: program_id,
1057: SYSDATE, /* program_update_date */
1058: p_oc_pri_qty,
1059: p_oc_pri_qty
1060: FROM wip_move_txn_allocations wmta
1061: WHERE wmta.transaction_id = p_parent_txn_id
1062: AND wmta.organization_id = p_org_id
1063: AND wmta.repetitive_schedule_id =
1064: (SELECT MAX(wmta1.repetitive_schedule_id)

Line 1065: FROM wip_move_txn_allocations wmta1

1061: WHERE wmta.transaction_id = p_parent_txn_id
1062: AND wmta.organization_id = p_org_id
1063: AND wmta.repetitive_schedule_id =
1064: (SELECT MAX(wmta1.repetitive_schedule_id)
1065: FROM wip_move_txn_allocations wmta1
1066: WHERE wmta1.transaction_id = wmta.transaction_id
1067: AND wmta1.organization_id = wmta.organization_id));
1068: END IF; -- p_scheID > 0
1069: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1361: wip_move_txn_allocations wma1

1357: DECODE(p_gib.program_id, -1, NULL, p_gib.program_id),
1358: DECODE(p_gib.request_id, -1, NULL, SYSDATE)
1359: FROM wip_operations wop1,
1360: wip_move_txn_interface wmti1,
1361: wip_move_txn_allocations wma1
1362: WHERE wop1.rowid = wop.rowid
1363: -- The WO rows to be updated are identIFied by the rowids.
1364: -- For each such row, go back and sum the quantities from WMTI
1365: AND wmti1.group_id = p_gib.group_id

Line 1382: wip_move_txn_allocations wma2

1378: WHERE wop.rowid =
1379: (SELECT wop2.rowid
1380: FROM wip_operations wop2,
1381: wip_move_txn_interface wmti2,
1382: wip_move_txn_allocations wma2
1383: WHERE wmti2.group_id = p_gib.group_id
1384: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)
1385: AND wmti2.transaction_id = p_txn_id
1386: -- Picked a Move txn

Line 1550: INSERT INTO wip_move_txn_allocations

1546:
1547: IF(l_proc_status = WIP_CONSTANTS.RUNNING) THEN
1548:
1549: FOR i IN 1..l_sche_count LOOP
1550: INSERT INTO wip_move_txn_allocations
1551: (transaction_id,
1552: repetitive_schedule_id,
1553: organization_id,
1554: last_update_date,

Line 3618: wip_move_txn_allocations wma,

3614: FROM bom_departments bd,
3615: bom_resources br,
3616: cst_activities ca,
3617: wip_operation_resources wor,
3618: wip_move_txn_allocations wma,
3619: wip_operations wop,
3620: wip_move_txn_interface wmti
3621: WHERE wmti.group_id = p_gib.group_id
3622: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4070: wip_move_txn_allocations wma,

4066: FROM bom_departments bd,
4067: bom_resources br,
4068: cst_activities ca,
4069: wip_operation_resources wor,
4070: wip_move_txn_allocations wma,
4071: wip_operations wop,
4072: wip_move_txn_interface wmti
4073: WHERE wmti.group_id = p_gib.group_id
4074: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4281: wip_move_txn_allocations wma,

4277: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4278:
4279: FROM wip_operation_resources wor,
4280: wip_operations wop,
4281: wip_move_txn_allocations wma,
4282: wip_cost_txn_interface wci,
4283: wip_move_txn_interface wmti
4284: WHERE wmti.group_id = p_gib.group_id
4285: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4433: wip_move_txn_allocations wmta,

4429: WIP_CONSTANTS.RUN),1, 1, -1)),
4430: 1, 1,
4431: -1,-1) -- primary_quantity
4432: FROM wip_operation_resources wor,
4433: wip_move_txn_allocations wmta,
4434: wip_move_txn_interface wmti,
4435: wip_cost_txn_interface wcti
4436: WHERE wcti.group_id = p_gib.group_id
4437: AND wcti.process_phase = WIP_CONSTANTS.RES_PROC

Line 4916: wip_move_txn_allocations wma,

4912: NULL, -- po_header_id
4913: NULL, -- po_line_id
4914: NULL -- repetitive_schedule_id
4915: FROM bom_departments bd,
4916: wip_move_txn_allocations wma,
4917: wip_operations wop,
4918: wip_move_txn_interface wmti,
4919: wip_operation_resources wor
4920: WHERE wmti.group_id = p_gib.group_id

Line 5368: wip_move_txn_allocations wma,

5364: NULL, -- po_header_id
5365: NULL, -- po_line_id
5366: wma.repetitive_schedule_id
5367: FROM bom_departments bd,
5368: wip_move_txn_allocations wma,
5369: wip_operations wop,
5370: wip_move_txn_interface wmti,
5371: wip_operation_resources wor
5372: WHERE wmti.group_id = p_gib.group_id

Line 5562: FROM wip_move_txn_allocations wma,

5558: ),0)), -- primary_quantity
5559: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
5560: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
5561: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
5562: FROM wip_move_txn_allocations wma,
5563: wip_operations wop,
5564: wip_cost_txn_interface wci,
5565: wip_move_txn_interface wmti
5566: WHERE wmti.group_id = p_gib.group_id

Line 6144: wip_move_txn_allocations wma,

6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6143: wip_operations wo2,
6144: wip_move_txn_allocations wma,
6145: wip_move_txn_interface wmti
6146: WHERE wmti.group_id = p_gib.group_id
6147: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6148: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 6572: wip_move_txn_allocations wma,

6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6571: wip_operations wo2,
6572: wip_move_txn_allocations wma,
6573: wip_move_txn_interface wmti
6574: WHERE wmti.group_id = p_gib.group_id
6575: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6576: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 7009: wip_move_txn_allocations wma1,

7005: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
7006: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
7007: DECODE(p_gib.request_id,-1,NULL,SYSDATE)-- program_update_date
7008: FROM wip_operations wop1,
7009: wip_move_txn_allocations wma1,
7010: wip_move_txn_interface wmti
7011: WHERE wop1.rowid = wop.rowid
7012: AND wmti.group_id = p_gib.group_id
7013: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)

Line 7057: wip_move_txn_allocations wma2,

7053: ))
7054: WHERE wop.rowid IN
7055: (SELECT wop2.rowid
7056: FROM wip_operations wop2,
7057: wip_move_txn_allocations wma2,
7058: wip_move_txn_interface wmti
7059: WHERE wop2.organization_id = wmti.organization_id
7060: AND wmti.group_id = p_gib.group_id
7061: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)

Line 7712: wip_move_txn_allocations wmta,

7708: WIP_CONSTANTS.REPETITIVE, wmta.primary_quantity,
7709: wmti.primary_quantity)) changed_qty,
7710: GREATEST(wmti.fm_operation_seq_num, wmti.to_operation_seq_num) fm_op
7711: FROM wip_move_txn_interface wmti,
7712: wip_move_txn_allocations wmta,
7713: wip_parameters mp
7714: WHERE wmti.transaction_id = wmta.transaction_id (+)
7715: AND wmti.organization_id = wmta.organization_id (+)
7716: AND wmti.group_id = p_gib.group_id

Line 9226: wip_move_txn_allocations wma1

9222: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
9223: DECODE(p_gib.request_id,-1,NULL,SYSDATE)
9224: FROM wip_requirement_operations wro1,
9225: wip_move_txn_interface wmti1,
9226: wip_move_txn_allocations wma1
9227: WHERE wro1.rowid = wro.rowid
9228: -- The WO rows to be updated are identIFied by the rowids.
9229: -- For each such row, go back and sum the quantities from WMTI
9230: AND wmti1.group_id = p_gib.group_id

Line 9247: wip_move_txn_allocations wma2

9243: WHERE wro.rowid in
9244: (SELECT wro2.rowid
9245: FROM wip_requirement_operations wro2,
9246: wip_move_txn_interface wmti2,
9247: wip_move_txn_allocations wma2
9248: WHERE wmti2.group_id = p_gib.group_id
9249: AND wmti2.process_phase = WIP_CONSTANTS.MOVE_PROC
9250: AND wmti2.process_status = WIP_CONSTANTS.RUNNING
9251: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)

Line 10692: FROM wip_move_txn_allocations wmta,

10688: sign(mmtt.primary_quantity), -- primary_quantity
10689: wmta.transaction_quantity *
10690: sign(mmtt.transaction_quantity), -- transaction_quantity
10691: wmti.transaction_date
10692: FROM wip_move_txn_allocations wmta,
10693: wip_move_txn_interface wmti,
10694: mtl_material_transactions_temp mmtt
10695: WHERE wmti.transaction_id = wmta.transaction_id
10696: AND wmti.organization_id = wmta.organization_id