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 1077: * and WIP_MOVE_TXN_ALLOCATIONS

1073:
1074: /*****************************************************************************
1075: * This procedure is equivalent to witoc_insert_alloc_child in wiltps.ppc
1076: * This procedure is used to insert child record into WIP_MOVE_TXN_INTERFACE
1077: * and WIP_MOVE_TXN_ALLOCATIONS
1078: ****************************************************************************/
1079: PROCEDURE insert_alloc_child(p_org_id IN NUMBER,
1080: p_scheID IN NUMBER,
1081: p_oc_pri_qty IN NUMBER,

Line 1151: -- to wip_move_txn_allocations as well

1147: END IF;
1148:
1149: IF(p_scheID > 0) THEN
1150: -- this is a repetitvie schedule, hence must insert allocation records
1151: -- to wip_move_txn_allocations as well
1152: INSERT INTO wip_move_txn_allocations
1153: (transaction_id,
1154: repetitive_schedule_id,
1155: organization_id,

Line 1152: INSERT INTO wip_move_txn_allocations

1148:
1149: IF(p_scheID > 0) THEN
1150: -- this is a repetitvie schedule, hence must insert allocation records
1151: -- to wip_move_txn_allocations as well
1152: INSERT INTO wip_move_txn_allocations
1153: (transaction_id,
1154: repetitive_schedule_id,
1155: organization_id,
1156: last_update_date,

Line 1181: FROM wip_move_txn_allocations wmta

1177: program_id,
1178: SYSDATE, /* program_update_date */
1179: p_oc_pri_qty,
1180: p_oc_pri_qty
1181: FROM wip_move_txn_allocations wmta
1182: WHERE wmta.transaction_id = p_parent_txn_id
1183: AND wmta.organization_id = p_org_id
1184: AND wmta.repetitive_schedule_id =
1185: (SELECT MAX(wmta1.repetitive_schedule_id)

Line 1186: FROM wip_move_txn_allocations wmta1

1182: WHERE wmta.transaction_id = p_parent_txn_id
1183: AND wmta.organization_id = p_org_id
1184: AND wmta.repetitive_schedule_id =
1185: (SELECT MAX(wmta1.repetitive_schedule_id)
1186: FROM wip_move_txn_allocations wmta1
1187: WHERE wmta1.transaction_id = wmta.transaction_id
1188: AND wmta1.organization_id = wmta.organization_id));
1189: END IF; -- p_scheID > 0
1190: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1482: wip_move_txn_allocations wma1

1478: DECODE(p_gib.program_id, -1, NULL, p_gib.program_id),
1479: DECODE(p_gib.request_id, -1, NULL, SYSDATE)
1480: FROM wip_operations wop1,
1481: wip_move_txn_interface wmti1,
1482: wip_move_txn_allocations wma1
1483: WHERE wop1.rowid = wop.rowid
1484: -- The WO rows to be updated are identIFied by the rowids.
1485: -- For each such row, go back and sum the quantities from WMTI
1486: AND wmti1.group_id = p_gib.group_id

Line 1503: wip_move_txn_allocations wma2

1499: WHERE wop.rowid =
1500: (SELECT wop2.rowid
1501: FROM wip_operations wop2,
1502: wip_move_txn_interface wmti2,
1503: wip_move_txn_allocations wma2
1504: WHERE wmti2.group_id = p_gib.group_id
1505: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)
1506: AND wmti2.transaction_id = p_txn_id
1507: -- Picked a Move txn

Line 1671: INSERT INTO wip_move_txn_allocations

1667:
1668: IF(l_proc_status = WIP_CONSTANTS.RUNNING) THEN
1669:
1670: FOR i IN 1..l_sche_count LOOP
1671: INSERT INTO wip_move_txn_allocations
1672: (transaction_id,
1673: repetitive_schedule_id,
1674: organization_id,
1675: last_update_date,

Line 3747: wip_move_txn_allocations wma,

3743: FROM bom_departments bd,
3744: bom_resources br,
3745: cst_activities ca,
3746: wip_operation_resources wor,
3747: wip_move_txn_allocations wma,
3748: wip_operations wop,
3749: wip_move_txn_interface wmti
3750: WHERE wmti.group_id = p_gib.group_id
3751: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4199: wip_move_txn_allocations wma,

4195: FROM bom_departments bd,
4196: bom_resources br,
4197: cst_activities ca,
4198: wip_operation_resources wor,
4199: wip_move_txn_allocations wma,
4200: wip_operations wop,
4201: wip_move_txn_interface wmti
4202: WHERE wmti.group_id = p_gib.group_id
4203: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4410: wip_move_txn_allocations wma,

4406: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4407:
4408: FROM wip_operation_resources wor,
4409: wip_operations wop,
4410: wip_move_txn_allocations wma,
4411: wip_cost_txn_interface wci,
4412: wip_move_txn_interface wmti
4413: WHERE wmti.group_id = p_gib.group_id
4414: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4562: wip_move_txn_allocations wmta,

4558: WIP_CONSTANTS.RUN),1, 1, -1)),
4559: 1, 1,
4560: -1,-1) -- primary_quantity
4561: FROM wip_operation_resources wor,
4562: wip_move_txn_allocations wmta,
4563: wip_move_txn_interface wmti,
4564: wip_cost_txn_interface wcti
4565: WHERE wcti.group_id = p_gib.group_id
4566: AND wcti.process_phase = WIP_CONSTANTS.RES_PROC

Line 5045: wip_move_txn_allocations wma,

5041: NULL, -- po_header_id
5042: NULL, -- po_line_id
5043: NULL -- repetitive_schedule_id
5044: FROM bom_departments bd,
5045: wip_move_txn_allocations wma,
5046: wip_operations wop,
5047: wip_move_txn_interface wmti,
5048: wip_operation_resources wor
5049: WHERE wmti.group_id = p_gib.group_id

Line 5497: wip_move_txn_allocations wma,

5493: NULL, -- po_header_id
5494: NULL, -- po_line_id
5495: wma.repetitive_schedule_id
5496: FROM bom_departments bd,
5497: wip_move_txn_allocations wma,
5498: wip_operations wop,
5499: wip_move_txn_interface wmti,
5500: wip_operation_resources wor
5501: WHERE wmti.group_id = p_gib.group_id

Line 5691: FROM wip_move_txn_allocations wma,

5687: ),0)), -- primary_quantity
5688: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
5689: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
5690: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
5691: FROM wip_move_txn_allocations wma,
5692: wip_operations wop,
5693: wip_cost_txn_interface wci,
5694: wip_move_txn_interface wmti
5695: WHERE wmti.group_id = p_gib.group_id

Line 6285: wip_move_txn_allocations wma,

6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6284: wip_operations wo2,
6285: wip_move_txn_allocations wma,
6286: wip_move_txn_interface wmti,
6287: wip_parameters wp /*ER 4276433*/
6288: WHERE wmti.group_id = p_gib.group_id
6289: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6727: wip_move_txn_allocations wma,

6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6726: wip_operations wo2,
6727: wip_move_txn_allocations wma,
6728: wip_move_txn_interface wmti,
6729: wip_parameters wp /*ER 4276433*/
6730: WHERE wmti.group_id = p_gib.group_id
6731: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 7208: wip_move_txn_allocations wma1,

7204: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
7205: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
7206: DECODE(p_gib.request_id,-1,NULL,SYSDATE)-- program_update_date
7207: FROM wip_operations wop1,
7208: wip_move_txn_allocations wma1,
7209: wip_move_txn_interface wmti
7210: WHERE wop1.rowid = wop.rowid
7211: AND wmti.group_id = p_gib.group_id
7212: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)

Line 7257: wip_move_txn_allocations wma2,

7253: ))
7254: WHERE wop.rowid IN
7255: (SELECT wop2.rowid
7256: FROM wip_operations wop2,
7257: wip_move_txn_allocations wma2,
7258: wip_move_txn_interface wmti
7259: WHERE wop2.organization_id = wmti.organization_id
7260: AND wmti.group_id = p_gib.group_id
7261: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)

Line 7913: wip_move_txn_allocations wmta,

7909: WIP_CONSTANTS.REPETITIVE, wmta.primary_quantity,
7910: wmti.primary_quantity)) changed_qty,
7911: GREATEST(wmti.fm_operation_seq_num, wmti.to_operation_seq_num) fm_op
7912: FROM wip_move_txn_interface wmti,
7913: wip_move_txn_allocations wmta,
7914: wip_parameters mp
7915: WHERE wmti.transaction_id = wmta.transaction_id (+)
7916: AND wmti.organization_id = wmta.organization_id (+)
7917: AND wmti.group_id = p_gib.group_id

Line 9499: wip_move_txn_allocations wma1

9495: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
9496: DECODE(p_gib.request_id,-1,NULL,SYSDATE)
9497: FROM wip_requirement_operations wro1,
9498: wip_move_txn_interface wmti1,
9499: wip_move_txn_allocations wma1
9500: WHERE wro1.rowid = wro.rowid
9501: -- The WO rows to be updated are identIFied by the rowids.
9502: -- For each such row, go back and sum the quantities from WMTI
9503: AND wmti1.group_id = p_gib.group_id

Line 9520: wip_move_txn_allocations wma2

9516: WHERE wro.rowid in
9517: (SELECT wro2.rowid
9518: FROM wip_requirement_operations wro2,
9519: wip_move_txn_interface wmti2,
9520: wip_move_txn_allocations wma2
9521: WHERE wmti2.group_id = p_gib.group_id
9522: AND wmti2.process_phase = WIP_CONSTANTS.MOVE_PROC
9523: AND wmti2.process_status = WIP_CONSTANTS.RUNNING
9524: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)

Line 11049: FROM wip_move_txn_allocations wmta,

11045: sign(mmtt.primary_quantity), -- primary_quantity
11046: wmta.transaction_quantity *
11047: sign(mmtt.transaction_quantity), -- transaction_quantity
11048: wmti.transaction_date
11049: FROM wip_move_txn_allocations wmta,
11050: wip_move_txn_interface wmti,
11051: mtl_material_transactions_temp mmtt
11052: WHERE wmti.transaction_id = wmta.transaction_id
11053: AND wmti.organization_id = wmta.organization_id