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.BOM_DELETE_ITEMS dependencies on BOM_DELETE_ENTITIES

Line 9: -- | Description : Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES |

5: -- | All rights reserved. |
6: -- +==========================================================================+
7: -- | |
8: -- | File Name : BOMDELTB.pls |
9: -- | Description : Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES |
10: -- | when called by BOMFDDEL (Item, BOM and Routing Delete Form |
11: -- | under the following conditions: |
12: -- | - called on return from Item Catalog Search |
13: -- | - Component or Routing Where Used request |

Line 89: UPDATE BOM_DELETE_ENTITIES

85: delete_group_id IN NUMBER
86: )
87: IS
88: BEGIN
89: UPDATE BOM_DELETE_ENTITIES
90: SET PRIOR_process_flag = 1
91: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
92: AND PRIOR_process_flag = 2;
93: EXCEPTION

Line 107: -- Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES

103: -- NAME
104: -- POPULATE_DELETE
105:
106: -- DESCRIPTION
107: -- Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES
108:
109: -- REQUIRES
110: -- org_id: organization id
111: -- last_login_id

Line 219: INSERT INTO BOM_DELETE_ENTITIES(

215: -- CASE 6 BOM AND ROUTING
216: -- CASE 7 ITEM/BOM AND ROUTING
217:
218: IF delete_type IN (1, 6, 7) THEN
219: INSERT INTO BOM_DELETE_ENTITIES(
220: DELETE_ENTITY_SEQUENCE_ID,
221: DELETE_GROUP_SEQUENCE_ID,
222: DELETE_ENTITY_TYPE,
223: INVENTORY_ITEM_ID,

Line 238: BOM_DELETE_ENTITIES_S.NEXTVAL,

234: CREATION_DATE,
235: CREATED_BY,
236: LAST_UPDATE_LOGIN)
237: SELECT
238: BOM_DELETE_ENTITIES_S.NEXTVAL,
239: delete_group_id,
240: 1,
241: MCSI.INVENTORY_ITEM_ID,
242: MCSI.ORGANIZATION_ID,

Line 269: FROM BOM_DELETE_ENTITIES

265: 7, item_eng_flag, MSI.ENG_ITEM_FLAG)
266: AND MCSI.GROUP_HANDLE_ID = catalog_search_id
267: AND MCSI.INVENTORY_ITEM_ID NOT IN(
268: SELECT DISTINCT INVENTORY_ITEM_ID
269: FROM BOM_DELETE_ENTITIES
270: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
271: AND ORGANIZATION_ID = org_id);
272:
273: DELETE MTL_CATALOG_SEARCH_ITEMS

Line 280: INSERT INTO BOM_DELETE_ENTITIES(

276: -- CASE 2 BOM
277: -- CASE 4 COMPONENT
278:
279: ELSIF delete_type IN (2, 4) THEN
280: INSERT INTO BOM_DELETE_ENTITIES(
281: DELETE_ENTITY_SEQUENCE_ID,
282: DELETE_GROUP_SEQUENCE_ID,
283: DELETE_ENTITY_TYPE,
284: INVENTORY_ITEM_ID,

Line 299: BOM_DELETE_ENTITIES_S.NEXTVAL,

295: CREATION_DATE,
296: CREATED_BY,
297: LAST_UPDATE_LOGIN)
298: SELECT
299: BOM_DELETE_ENTITIES_S.NEXTVAL,
300: delete_group_id,
301: 2,
302: BOM.ASSEMBLY_ITEM_ID,
303: BOM.ORGANIZATION_ID,

Line 329: FROM BOM_DELETE_ENTITIES

325: AND BOM.ASSEMBLY_TYPE = eng_flag
326: AND MCSI.GROUP_HANDLE_ID = catalog_search_id
327: AND BOM.BILL_SEQUENCE_ID NOT IN(
328: SELECT NVL(BILL_SEQUENCE_ID, 0)
329: FROM BOM_DELETE_ENTITIES
330: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
331:
332: DELETE MTL_CATALOG_SEARCH_ITEMS
333: WHERE GROUP_HANDLE_ID = catalog_search_id;

Line 339: INSERT INTO BOM_DELETE_ENTITIES(

335: -- CASE 3 ROUTING
336: -- CASE 5 OPERATION
337:
338: ELSIF delete_type IN (3, 5) THEN
339: INSERT INTO BOM_DELETE_ENTITIES(
340: DELETE_ENTITY_SEQUENCE_ID,
341: DELETE_GROUP_SEQUENCE_ID,
342: DELETE_ENTITY_TYPE,
343: INVENTORY_ITEM_ID,

Line 358: BOM_DELETE_ENTITIES_S.NEXTVAL,

354: CREATION_DATE,
355: CREATED_BY,
356: LAST_UPDATE_LOGIN)
357: SELECT
358: BOM_DELETE_ENTITIES_S.NEXTVAL,
359: delete_group_id,
360: 3,
361: BOR.ASSEMBLY_ITEM_ID,
362: BOR.ORGANIZATION_ID,

Line 388: FROM BOM_DELETE_ENTITIES

384: AND BOR.ROUTING_TYPE = eng_flag
385: AND MCSI.GROUP_HANDLE_ID = catalog_search_id
386: AND BOR.ROUTING_SEQUENCE_ID NOT IN(
387: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
388: FROM BOM_DELETE_ENTITIES
389: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
390: AND ORGANIZATION_ID = org_id);
391: DELETE MTL_CATALOG_SEARCH_ITEMS
392: WHERE GROUP_HANDLE_ID = catalog_search_id;

Line 411: INSERT INTO BOM_DELETE_ENTITIES(

407:
408: -- COMPONENT ID: NULL, EXPIRATION DATE: NOT NULL
409:
410: IF component_id <= 0 THEN
411: INSERT INTO BOM_DELETE_ENTITIES(
412: DELETE_ENTITY_SEQUENCE_ID,
413: DELETE_GROUP_SEQUENCE_ID,
414: DELETE_ENTITY_TYPE,
415: INVENTORY_ITEM_ID,

Line 429: BOM_DELETE_ENTITIES_S.NEXTVAL,

425: CREATION_DATE,
426: CREATED_BY,
427: LAST_UPDATE_LOGIN)
428: SELECT
429: BOM_DELETE_ENTITIES_S.NEXTVAL,
430: delete_group_id,
431: 2,
432: BOM.ASSEMBLY_ITEM_ID,
433: BOM.ORGANIZATION_ID,

Line 464: FROM BOM_DELETE_ENTITIES

460: AND BOM.ASSEMBLY_TYPE = eng_flag
461: AND expiration_date >= BIC.DISABLE_DATE
462: AND BOM.BILL_SEQUENCE_ID NOT IN(
463: SELECT NVL(BILL_SEQUENCE_ID, 0)
464: FROM BOM_DELETE_ENTITIES
465: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id));
466:
467: INSERT INTO BOM_DELETE_SUB_ENTITIES(
468: DELETE_ENTITY_SEQUENCE_ID,

Line 501: BOM_DELETE_ENTITIES BDE,

497: userid,
498: last_login_id
499: FROM
500: BOM_INVENTORY_COMPONENTS BIC,
501: BOM_DELETE_ENTITIES BDE,
502: BOM_BILL_OF_MATERIALS BOM,
503: MTL_SYSTEM_ITEMS MSI,
504: MTL_ITEM_FLEXFIELDS MIF
505: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID

Line 518: BOM_DELETE_ENTITIES BDE

514: AND BIC.COMPONENT_SEQUENCE_ID NOT IN(
515: SELECT NVL(COMPONENT_SEQUENCE_ID, 0)
516: FROM
517: BOM_DELETE_SUB_ENTITIES BDSE,
518: BOM_DELETE_ENTITIES BDE
519: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
520: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
521:
522: -- COMPONENT ID: NOT NULL, EXPIRATION DATE: NOT NULL OR NULL

Line 535: INSERT INTO BOM_DELETE_ENTITIES(

531: -- NULL NOT NULL RETAIN ROW
532: -- NULL NULL RETAIN ROW
533:
534: ELSE
535: INSERT INTO BOM_DELETE_ENTITIES(
536: DELETE_ENTITY_SEQUENCE_ID,
537: DELETE_GROUP_SEQUENCE_ID,
538: DELETE_ENTITY_TYPE,
539: INVENTORY_ITEM_ID,

Line 553: BOM_DELETE_ENTITIES_S.NEXTVAL,

549: CREATION_DATE,
550: CREATED_BY,
551: LAST_UPDATE_LOGIN)
552: SELECT
553: BOM_DELETE_ENTITIES_S.NEXTVAL,
554: delete_group_id,
555: 2,
556: BOM.ASSEMBLY_ITEM_ID,
557: BOM.ORGANIZATION_ID,

Line 590: FROM BOM_DELETE_ENTITIES

586: AND NVL(expiration_date, NVL(BIC.DISABLE_DATE, TRUNC(SYSDATE))) >=
587: NVL(BIC.DISABLE_DATE, NVL(expiration_date+1, TRUNC(SYSDATE)))
588: AND BOM.BILL_SEQUENCE_ID NOT IN(
589: SELECT NVL(BILL_SEQUENCE_ID, 0)
590: FROM BOM_DELETE_ENTITIES
591: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id));
592:
593: -- THE EXPIRATION_DATE/DISABLE_DATE WHERE CLAUSE BELOW IS OBSCURE
594: -- EXPECTED BEHAVIOR:

Line 637: BOM_DELETE_ENTITIES BDE,

633: userid,
634: last_login_id
635: FROM
636: BOM_INVENTORY_COMPONENTS BIC,
637: BOM_DELETE_ENTITIES BDE,
638: BOM_BILL_OF_MATERIALS BOM,
639: MTL_SYSTEM_ITEMS MSI,
640: MTL_ITEM_FLEXFIELDS MIF
641: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID

Line 656: BOM_DELETE_ENTITIES BDE

652: AND BIC.COMPONENT_SEQUENCE_ID NOT IN(
653: SELECT NVL(COMPONENT_SEQUENCE_ID, 0)
654: FROM
655: BOM_DELETE_SUB_ENTITIES BDSE,
656: BOM_DELETE_ENTITIES BDE
657: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
658: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
659: END IF; -- END OF COMPONENT WHERE USED SEARCH
660: RAISE finale;

Line 665: INSERT INTO BOM_DELETE_ENTITIES(

661:
662: -- OPERATION WHERE USED
663:
664: ELSIF delete_type = 5 THEN
665: INSERT INTO BOM_DELETE_ENTITIES(
666: DELETE_ENTITY_SEQUENCE_ID,
667: DELETE_GROUP_SEQUENCE_ID,
668: DELETE_ENTITY_TYPE,
669: INVENTORY_ITEM_ID,

Line 683: BOM_DELETE_ENTITIES_S.NEXTVAL,

679: CREATION_DATE,
680: CREATED_BY,
681: LAST_UPDATE_LOGIN)
682: SELECT
683: BOM_DELETE_ENTITIES_S.NEXTVAL,
684: delete_group_id,
685: 3,
686: BOR.ASSEMBLY_ITEM_ID,
687: BOR.ORGANIZATION_ID,

Line 718: FROM BOM_DELETE_ENTITIES

714: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
715: AND BOS.DISABLE_DATE <= expiration_date
716: AND BOS.ROUTING_SEQUENCE_ID NOT IN(
717: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
718: FROM BOM_DELETE_ENTITIES
719: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id));
720:
721: INSERT INTO BOM_DELETE_SUB_ENTITIES(
722: DELETE_ENTITY_SEQUENCE_ID,

Line 751: BOM_DELETE_ENTITIES BDE,

747: userid,
748: last_login_id
749: FROM
750: BOM_OPERATION_SEQUENCES BOS,
751: BOM_DELETE_ENTITIES BDE,
752: BOM_OPERATIONAL_ROUTINGS BOR,
753: BOM_DEPARTMENTS BD
754: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
755: AND BDE.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID

Line 764: BOM_DELETE_ENTITIES BDE

760: AND BOS.OPERATION_SEQUENCE_ID NOT IN(
761: SELECT NVL(OPERATION_SEQUENCE_ID, 0)
762: FROM
763: BOM_DELETE_SUB_ENTITIES BDSE,
764: BOM_DELETE_ENTITIES BDE
765: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
766: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
767: RAISE finale;
768: ELSE

Line 811: FROM BOM_DELETE_ENTITIES

807: ELSE -- MASTER ORG
808: DECLARE
809: CURSOR GetDelEntities IS
810: SELECT DELETE_ENTITY_SEQUENCE_ID, INVENTORY_ITEM_ID
811: FROM BOM_DELETE_ENTITIES
812: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
813: AND PRIOR_PROCESS_FLAG = 2;
814: BEGIN
815:

Line 816: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR THE ITEM IN ALL CHILD ORGS

812: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
813: AND PRIOR_PROCESS_FLAG = 2;
814: BEGIN
815:
816: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR THE ITEM IN ALL CHILD ORGS
817: FOR GetDelEntitiesREC IN GetDelEntities LOOP
818: INSERT INTO BOM_DELETE_ENTITIES(
819: DELETE_ENTITY_SEQUENCE_ID,
820: DELETE_GROUP_SEQUENCE_ID,

Line 818: INSERT INTO BOM_DELETE_ENTITIES(

814: BEGIN
815:
816: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR THE ITEM IN ALL CHILD ORGS
817: FOR GetDelEntitiesREC IN GetDelEntities LOOP
818: INSERT INTO BOM_DELETE_ENTITIES(
819: DELETE_ENTITY_SEQUENCE_ID,
820: DELETE_GROUP_SEQUENCE_ID,
821: DELETE_ENTITY_TYPE,
822: INVENTORY_ITEM_ID,

Line 834: BOM_DELETE_ENTITIES_S.NEXTVAL,

830: LAST_UPDATED_BY,
831: CREATION_DATE,
832: CREATED_BY)
833: SELECT
834: BOM_DELETE_ENTITIES_S.NEXTVAL,
835: delete_group_id,
836: 1,
837: MSI.INVENTORY_ITEM_ID,
838: MSI.ORGANIZATION_ID,

Line 862: FROM BOM_DELETE_ENTITIES

858: WHERE MASTER_ORGANIZATION_ID = org_id
859: AND ORGANIZATION_ID <> MASTER_ORGANIZATION_ID)
860: AND MSI.ORGANIZATION_ID NOT IN(
861: SELECT DISTINCT ORGANIZATION_ID
862: FROM BOM_DELETE_ENTITIES
863: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
864: AND INVENTORY_ITEM_ID = GetDelEntitiesREC.INVENTORY_ITEM_ID);
865: END LOOP; -- FOR
866: IF delete_type = 1 THEN

Line 880: FROM BOM_DELETE_ENTITIES

876: IF delete_type IN (6, 7) THEN
877: DECLARE
878: CURSOR BR_GetDelEntities IS
879: SELECT DELETE_ENTITY_SEQUENCE_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID
880: FROM BOM_DELETE_ENTITIES
881: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
882: AND PRIOR_PROCESS_FLAG = 2;
883: BEGIN
884:

Line 885: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL BOMS AND ALTERNATES

881: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id
882: AND PRIOR_PROCESS_FLAG = 2;
883: BEGIN
884:
885: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL BOMS AND ALTERNATES
886:
887: FOR BR_GetDelEntitiesREC IN BR_GetDelEntities LOOP
888: INSERT INTO BOM_DELETE_ENTITIES(
889: DELETE_ENTITY_SEQUENCE_ID,

Line 888: INSERT INTO BOM_DELETE_ENTITIES(

884:
885: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL BOMS AND ALTERNATES
886:
887: FOR BR_GetDelEntitiesREC IN BR_GetDelEntities LOOP
888: INSERT INTO BOM_DELETE_ENTITIES(
889: DELETE_ENTITY_SEQUENCE_ID,
890: DELETE_GROUP_SEQUENCE_ID,
891: DELETE_ENTITY_TYPE,
892: INVENTORY_ITEM_ID,

Line 906: BOM_DELETE_ENTITIES_S.NEXTVAL,

902: LAST_UPDATED_BY,
903: CREATION_DATE,
904: CREATED_BY)
905: SELECT
906: BOM_DELETE_ENTITIES_S.NEXTVAL,
907: delete_group_id,
908: 2,
909: BOM.ASSEMBLY_ITEM_ID,
910: BOM.ORGANIZATION_ID,

Line 935: FROM BOM_DELETE_ENTITIES

931: AND MIF.ORGANIZATION_ID = BOM.ORGANIZATION_ID
932: AND BOM.ASSEMBLY_TYPE = eng_flag
933: AND BOM.BILL_SEQUENCE_ID NOT IN(
934: SELECT NVL(BILL_SEQUENCE_ID, 0)
935: FROM BOM_DELETE_ENTITIES
936: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
937:
938: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL ROUTINGS AND ALTERNATES
939:

Line 938: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL ROUTINGS AND ALTERNATES

934: SELECT NVL(BILL_SEQUENCE_ID, 0)
935: FROM BOM_DELETE_ENTITIES
936: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
937:
938: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL ROUTINGS AND ALTERNATES
939:
940: INSERT INTO BOM_DELETE_ENTITIES(
941: DELETE_ENTITY_SEQUENCE_ID,
942: DELETE_GROUP_SEQUENCE_ID,

Line 940: INSERT INTO BOM_DELETE_ENTITIES(

936: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
937:
938: -- INSERT ROW IN BOM_DELETE_ENTITIES FOR ALL ROUTINGS AND ALTERNATES
939:
940: INSERT INTO BOM_DELETE_ENTITIES(
941: DELETE_ENTITY_SEQUENCE_ID,
942: DELETE_GROUP_SEQUENCE_ID,
943: DELETE_ENTITY_TYPE,
944: INVENTORY_ITEM_ID,

Line 958: BOM_DELETE_ENTITIES_S.NEXTVAL,

954: LAST_UPDATED_BY,
955: CREATION_DATE,
956: CREATED_BY)
957: SELECT
958: BOM_DELETE_ENTITIES_S.NEXTVAL,
959: delete_group_id,
960: 3,
961: BOR.ASSEMBLY_ITEM_ID,
962: BOR.ORGANIZATION_ID,

Line 987: FROM BOM_DELETE_ENTITIES

983: AND MIF.ORGANIZATION_ID = BOR.ORGANIZATION_ID
984: AND BOR.ROUTING_TYPE = eng_flag
985: AND BOR.ROUTING_SEQUENCE_ID NOT IN(
986: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
987: FROM BOM_DELETE_ENTITIES
988: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
989:
990: -- DELETE ROW IN BOM_DELETE_ENTITIES FOR BILL AND ROUTING
991: -- THAT WAS THE ITEM PLACE HOLDER (CURRENT OF CURSOR)

Line 990: -- DELETE ROW IN BOM_DELETE_ENTITIES FOR BILL AND ROUTING

986: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
987: FROM BOM_DELETE_ENTITIES
988: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id);
989:
990: -- DELETE ROW IN BOM_DELETE_ENTITIES FOR BILL AND ROUTING
991: -- THAT WAS THE ITEM PLACE HOLDER (CURRENT OF CURSOR)
992:
993: IF delete_type = 6 THEN
994: DELETE

Line 995: FROM BOM_DELETE_ENTITIES

991: -- THAT WAS THE ITEM PLACE HOLDER (CURRENT OF CURSOR)
992:
993: IF delete_type = 6 THEN
994: DELETE
995: FROM BOM_DELETE_ENTITIES
996: WHERE DELETE_ENTITY_SEQUENCE_ID =
997: BR_GetDelEntitiesREC.DELETE_ENTITY_SEQUENCE_ID;
998: END IF;
999: