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_OPERATIONS_UTILITIES dependencies on WIP_REQUIREMENT_OPERATIONS

Line 593: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

589:
590: /* Update the department and date required of requirements to
591: those of their new operation */
592:
593: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
594: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop,
595: DEPARTMENT_ID = firstdep,
596: DATE_REQUIRED = firstdate
597: WHERE ORGANIZATION_ID = X_Organization_Id

Line 602: FROM WIP_REQUIREMENT_OPERATIONS

598: AND WIP_ENTITY_ID = X_Wip_Entity_Id
599: AND OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * X_Operation_Seq_Num
600: AND NOT EXISTS
601: (SELECT 'checking for duplicate requirements'
602: FROM WIP_REQUIREMENT_OPERATIONS
603: WHERE ORGANIZATION_ID = X_Organization_Id
604: AND WIP_ENTITY_ID = X_Wip_Entity_Id
605: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * firstop
606: AND INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID);

Line 616: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

612: there are no other ops.
613: */
614:
615: IF X_Operation_Seq_Num NOT IN (-1, 1) OR firstdep IS NOT NULL THEN
616: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
617: SET (WIP_SUPPLY_TYPE, REQUIRED_QUANTITY,
618: QUANTITY_ISSUED, QUANTITY_PER_ASSEMBLY) =
619: (SELECT LEAST(WRO.WIP_SUPPLY_TYPE, WIP_SUPPLY_TYPE),
620: WRO.REQUIRED_QUANTITY + REQUIRED_QUANTITY,

Line 623: FROM WIP_REQUIREMENT_OPERATIONS

619: (SELECT LEAST(WRO.WIP_SUPPLY_TYPE, WIP_SUPPLY_TYPE),
620: WRO.REQUIRED_QUANTITY + REQUIRED_QUANTITY,
621: WRO.QUANTITY_ISSUED + QUANTITY_ISSUED,
622: WRO.QUANTITY_PER_ASSEMBLY + QUANTITY_PER_ASSEMBLY
623: FROM WIP_REQUIREMENT_OPERATIONS
624: WHERE ORGANIZATION_ID = X_Organization_Id
625: AND WIP_ENTITY_ID = X_Wip_Entity_Id
626: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) *
627: X_Operation_Seq_Num

Line 634: FROM WIP_REQUIREMENT_OPERATIONS

630: AND WIP_ENTITY_ID = X_Wip_Entity_Id
631: AND OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop
632: AND EXISTS
633: (SELECT 'checking for duplicate requirements'
634: FROM WIP_REQUIREMENT_OPERATIONS
635: WHERE ORGANIZATION_ID = X_Organization_Id
636: AND WIP_ENTITY_ID = X_Wip_Entity_Id
637: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * X_Operation_Seq_Num
638: AND INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID);

Line 640: DELETE FROM WIP_REQUIREMENT_OPERATIONS

636: AND WIP_ENTITY_ID = X_Wip_Entity_Id
637: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * X_Operation_Seq_Num
638: AND INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID);
639:
640: DELETE FROM WIP_REQUIREMENT_OPERATIONS
641: WHERE ORGANIZATION_ID = X_Organization_Id
642: AND WIP_ENTITY_ID = X_Wip_Entity_Id
643: AND (OPERATION_SEQ_NUM = X_Operation_Seq_Num
644: OR OPERATION_SEQ_NUM = X_Operation_Seq_Num * -1);

Line 652: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

648: Date Required might need to be reset */
649:
650: ELSE
651:
652: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
653: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop,
654: DEPARTMENT_ID = firstdep,
655: DATE_REQUIRED = firstdate
656: WHERE ORGANIZATION_ID = X_Organization_Id

Line 669: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

665: ELSE
666:
667: /* Update the department and date required of requirements to
668: those of their new operation */
669: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
670: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop,
671: DEPARTMENT_ID = firstdep,
672: DATE_REQUIRED = firstdate
673: WHERE ORGANIZATION_ID = X_Organization_Id

Line 679: FROM WIP_REQUIREMENT_OPERATIONS

675: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
676: AND OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * X_Operation_Seq_Num
677: AND NOT EXISTS
678: (SELECT 'checking for duplicate requirements'
679: FROM WIP_REQUIREMENT_OPERATIONS
680: WHERE ORGANIZATION_ID = X_Organization_Id
681: AND WIP_ENTITY_ID = X_Wip_Entity_Id
682: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
683: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * firstop

Line 694: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

690: there are no other ops.
691: */
692:
693: IF X_Operation_Seq_Num NOT IN (-1, 1) OR firstdep IS NOT NULL THEN
694: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
695: SET (WIP_SUPPLY_TYPE, REQUIRED_QUANTITY,
696: QUANTITY_ISSUED, QUANTITY_PER_ASSEMBLY) =
697: (SELECT LEAST(WRO.WIP_SUPPLY_TYPE, WIP_SUPPLY_TYPE),
698: WRO.REQUIRED_QUANTITY + REQUIRED_QUANTITY,

Line 701: FROM WIP_REQUIREMENT_OPERATIONS

697: (SELECT LEAST(WRO.WIP_SUPPLY_TYPE, WIP_SUPPLY_TYPE),
698: WRO.REQUIRED_QUANTITY + REQUIRED_QUANTITY,
699: WRO.QUANTITY_ISSUED + QUANTITY_ISSUED,
700: WRO.QUANTITY_PER_ASSEMBLY + QUANTITY_PER_ASSEMBLY
701: FROM WIP_REQUIREMENT_OPERATIONS
702: WHERE ORGANIZATION_ID = X_Organization_Id
703: AND WIP_ENTITY_ID = X_Wip_Entity_Id
704: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
705: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) *

Line 714: FROM WIP_REQUIREMENT_OPERATIONS

710: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
711: AND OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop
712: AND EXISTS
713: (SELECT 'checking for duplicate requirements'
714: FROM WIP_REQUIREMENT_OPERATIONS
715: WHERE ORGANIZATION_ID = X_Organization_Id
716: AND WIP_ENTITY_ID = X_Wip_Entity_Id
717: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
718: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * X_Operation_Seq_Num

Line 721: DELETE FROM WIP_REQUIREMENT_OPERATIONS

717: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
718: AND OPERATION_SEQ_NUM = SIGN(WRO.OPERATION_SEQ_NUM) * X_Operation_Seq_Num
719: AND INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID);
720:
721: DELETE FROM WIP_REQUIREMENT_OPERATIONS
722: WHERE ORGANIZATION_ID = X_Organization_Id
723: AND WIP_ENTITY_ID = X_Wip_Entity_Id
724: AND (OPERATION_SEQ_NUM = X_Operation_Seq_Num
725: OR OPERATION_SEQ_NUM = X_Operation_Seq_Num * -1)

Line 734: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

730: Date Required might need to be reset */
731:
732: ELSE
733:
734: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
735: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) * firstop,
736: DEPARTMENT_ID = firstdep,
737: DATE_REQUIRED = firstdate
738: WHERE ORGANIZATION_ID = X_Organization_Id

Line 759: FROM WIP_REQUIREMENT_OPERATIONS

755: BEGIN
756: IF X_Repetitive_Schedule_Id IS NULL THEN
757: SELECT count(*)
758: INTO opseq
759: FROM WIP_REQUIREMENT_OPERATIONS
760: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
761: AND ORGANIZATION_ID = X_Organization_Id
762: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
763: AND WIP_SUPPLY_TYPE = 2;

Line 767: FROM WIP_REQUIREMENT_OPERATIONS

763: AND WIP_SUPPLY_TYPE = 2;
764: ELSE
765: SELECT count(*)
766: INTO opseq
767: FROM WIP_REQUIREMENT_OPERATIONS
768: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
769: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
770: AND ORGANIZATION_ID = X_Organization_Id
771: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num

Line 897: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

893: --Bug#14835310 : Added not exists condition so that when pending transactions exist, the operation_seq_num is not updated
894: --Quantity_issued should be equal to 0 so that already transacted components are not updated
895: --Bug#16373586: Updating only when no pending transactions exist in MMTT. MTI is not checked here as customers can directly insert into MTI
896: -- Also, the source_type should not be WIP. In case of backflush transfer, the source type is INV.
897: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
898: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) *
899: X_Operation_Seq_Num,
900: DEPARTMENT_ID = X_Department_Id,
901: DATE_REQUIRED = X_First_Unit_Start_Date

Line 910: UPDATE WIP_REQUIREMENT_OPERATIONS wro

906: AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
907: WHERE MMTT.TRANSACTION_SOURCE_ID=X_Wip_Entity_Id and MMTT.organization_id=X_Organization_Id and MMTT.operation_seq_num in (-1,1)
908: and MMTT.inventory_item_id=WRO.INVENTORY_ITEM_ID AND mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP);
909: ELSE
910: UPDATE WIP_REQUIREMENT_OPERATIONS wro
911: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) *
912: X_Operation_Seq_Num,
913: DEPARTMENT_ID = X_Department_Id,
914: DATE_REQUIRED = X_First_Unit_Start_Date

Line 936: UPDATE WIP_REQUIREMENT_OPERATIONS

932: X_Start_Date DATE) IS
933: BEGIN
934: /* Added nvl(X_department_id) for bug 5979782 (base bug 5657251)*/
935: IF X_Repetitive_Schedule_Id IS NULL THEN
936: UPDATE WIP_REQUIREMENT_OPERATIONS
937: SET DEPARTMENT_ID = nvl(X_Department_Id,department_id),
938: --Start : Fix for bug #5177994/5094448 --
939: DATE_REQUIRED = trunc(NVL(X_Start_Date,DATE_REQUIRED)),
940: MPS_DATE_REQUIRED = trunc(NVL(X_Start_Date,MPS_DATE_REQUIRED))

Line 949: UPDATE WIP_REQUIREMENT_OPERATIONS

945: AND WIP_ENTITY_ID = X_Wip_Entity_Id
946: AND (OPERATION_SEQ_NUM = X_Operation_Seq_Num
947: OR OPERATION_SEQ_NUM = -1 * X_Operation_Seq_Num);
948: ELSE
949: UPDATE WIP_REQUIREMENT_OPERATIONS
950: SET DEPARTMENT_ID = X_Department_Id,
951: --Start : Fix for bug #5177994/5094448 --
952: DATE_REQUIRED = trunc(NVL(X_Start_Date,DATE_REQUIRED)),
953: MPS_DATE_REQUIRED = trunc(NVL(X_Start_Date,MPS_DATE_REQUIRED))