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_MTLPROC_PRIV dependencies on WIP_REPETITIVE_SCHEDULES

Line 653: wip_repetitive_schedules wrs

649: select wro.repetitive_schedule_id,
650: wro.required_quantity - wro.quantity_issued
651: bulk collect into x_schedTbl, x_qtyTbl
652: from wip_requirement_operations wro,
653: wip_repetitive_schedules wrs
654: where wro.wip_entity_id = p_issueRec.wipEntityID
655: and wro.inventory_item_id = p_issueRec.itemID
656: and wro.operation_seq_num = p_issueRec.opSeqNum
657: and sign(wro.quantity_per_assembly) = sign(p_issueRec.negReqFlag)

Line 669: wip_repetitive_schedules wrs

665: select wro.repetitive_schedule_id,--same as issue cursor above except for order by
666: wro.quantity_issued
667: bulk collect into x_schedTbl, x_qtyTbl
668: from wip_requirement_operations wro,
669: wip_repetitive_schedules wrs
670: where wro.wip_entity_id = p_issueRec.wipEntityID
671: and wro.inventory_item_id = p_issueRec.itemID
672: and wro.operation_seq_num = p_issueRec.opSeqNum
673: and sign(wro.quantity_per_assembly) = sign(p_issueRec.negReqFlag)

Line 701: from wip_repetitive_schedules wrs,

697: round( wro.quantity_per_assembly * wmta.primary_quantity
698: / decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)),
699: wip_constants.inv_max_precision)
700: bulk collect into x_schedTbl, x_qtyTbl
701: from wip_repetitive_schedules wrs,
702: wip_requirement_operations wro,
703: wip_move_txn_allocations wmta
704: where wmta.transaction_id = p_issueRec.movTxnID
705: and wro.repetitive_schedule_id = wmta.repetitive_schedule_id

Line 723: from wip_repetitive_schedules wrs,

719: round( wro.quantity_per_assembly * wmta.primary_quantity
720: / decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)),
721: wip_constants.inv_max_precision)
722: bulk collect into x_schedTbl, x_qtyTbl
723: from wip_repetitive_schedules wrs,
724: wip_requirement_operations wro,
725: wip_move_txn_allocations wmta
726: where wmta.transaction_id = p_issueRec.movTxnID
727: and wro.repetitive_schedule_id = wmta.repetitive_schedule_id

Line 752: from wip_repetitive_schedules wrs,

748: if(p_issueRec.txnActionID in (wip_constants.isscomp_action, wip_constants.issnegc_action)) then
749: select wro.repetitive_schedule_id,
750: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
751: bulk collect into x_schedTbl, x_qtyTbl
752: from wip_repetitive_schedules wrs,
753: wip_requirement_operations wro,
754: mtl_material_txn_allocations mmta,
755: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
756: where mmta.transaction_id = mmtt.material_allocation_temp_id

Line 780: from wip_repetitive_schedules wrs,

776: if sql%NOTFOUND then
777: select wro.repetitive_schedule_id,
778: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
779: bulk collect into x_schedTbl, x_qtyTbl
780: from wip_repetitive_schedules wrs,
781: wip_requirement_operations wro,
782: wip_mtl_allocations_temp wmat,
783: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
784: where wmat.transaction_temp_id = mmtt.transaction_temp_id

Line 804: from wip_repetitive_schedules wrs,

800: else --return txn
801: select wro.repetitive_schedule_id,
802: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
803: bulk collect into x_schedTbl, x_qtyTbl
804: from wip_repetitive_schedules wrs,
805: wip_requirement_operations wro,
806: mtl_material_txn_allocations mmta,
807: mtl_material_transactions_temp mmtt
808: where mmta.transaction_id = mmtt.material_allocation_temp_id

Line 831: from wip_repetitive_schedules wrs,

827: if sql%NOTFOUND then
828: select wro.repetitive_schedule_id,
829: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
830: bulk collect into x_schedTbl, x_qtyTbl
831: from wip_repetitive_schedules wrs,
832: wip_requirement_operations wro,
833: wip_mtl_allocations_temp wmat,
834: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
835: where wmat.transaction_temp_id = mmtt.transaction_temp_id

Line 859: from wip_repetitive_schedules wrs,

855: if(p_issueRec.txnActionID in (wip_constants.isscomp_action, wip_constants.issnegc_action)) then
856: select wro.repetitive_schedule_id,
857: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
858: bulk collect into x_schedTbl, x_qtyTbl
859: from wip_repetitive_schedules wrs,
860: wip_requirement_operations wro,
861: mtl_material_txn_allocations mmta,
862: mtl_material_transactions mmt
863: where mmta.transaction_id = mmt.transaction_id

Line 881: from wip_repetitive_schedules wrs,

877: else --return txn
878: select wro.repetitive_schedule_id,
879: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
880: bulk collect into x_schedTbl, x_qtyTbl
881: from wip_repetitive_schedules wrs,
882: wip_requirement_operations wro,
883: mtl_material_txn_allocations mmta,
884: mtl_material_transactions mmt
885: where mmta.transaction_id = mmt.transaction_id

Line 1030: from wip_repetitive_schedules wrs

1026: if(l_excessQtySchedID is null) then
1027: /* Fix for bug 5373061: Added status_type and date_released checks to pick valid schedules only */
1028: select repetitive_schedule_id --the requirement doesn't exist. Find the earliest open schedule
1029: into l_excessQtySchedID
1030: from wip_repetitive_schedules wrs
1031: where wrs.wip_entity_id = p_issueRec.wipEntityID
1032: and wrs.line_id = p_issueRec.repLineID
1033: and wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)
1034: and wrs.date_released < p_issueRec.txnDate

Line 1036: from wip_repetitive_schedules

1032: and wrs.line_id = p_issueRec.repLineID
1033: and wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)
1034: and wrs.date_released < p_issueRec.txnDate
1035: and first_unit_start_date = (select min(first_unit_start_date)
1036: from wip_repetitive_schedules
1037: where wip_entity_id = p_issueRec.wipEntityID
1038: and line_id = p_issueRec.repLineID
1039: and status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)
1040: and date_released < p_issueRec.txnDate)