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_OPEN_INTERFACE_UTL dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 509: BOM_INVENTORY_COMPS_INTERFACE

505: Populate the user-friendly columns to Component records in the interface table
506: REQUIRES
507:
508: MODIFIES
509: BOM_INVENTORY_COMPS_INTERFACE
510: MTL_INTERFACE_ERRORS
511: RETURNS
512: 0 if successful
513: SQLCODE if unsuccessful

Line 542: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

538:
539: stmt_num := 1;
540: /* Resolve the Component_sequence_ids for updates and deletes */
541:
542: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
543: SET(bill_sequence_id, component_item_id, effectivity_date,
544: operation_seq_num, from_end_item_unit_number)
545: = (SELECT bill_sequence_id, component_item_id,
546: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 565: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

561:
562: stmt_num := 2;
563: /* Resolve the Bill sequence ids for updates and deletes */
564:
565: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
566: SET(assembly_item_id, organization_id, alternate_bom_designator)
567: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
568: FROM bom_structures_b BBM1
569: WHERE BBM1.bill_sequence_id = BICI.bill_sequence_id)

Line 587: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

583: stmt_num := 3;
584: /* Update Organization Code using Organization_id
585: this also needed if Organization_id is given and code is not given*/
586:
587: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
588: SET organization_code = (SELECT organization_code
589: FROM MTL_PARAMETERS mp1
590: WHERE mp1.organization_id = BICI.organization_id)
591: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 609: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

605: stmt_num := 4;
606: /* Update Organization_ids if organization_code is given org id is null.
607: Orgnaization_id information is needed in the next steps */
608:
609: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
610: SET organization_id = (SELECT organization_id
611: FROM MTL_PARAMETERS mp1
612: WHERE mp1.organization_code = BICI.organization_code)
613: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 628: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

624:
625: stmt_num := 5;
626: /* Update Assembly Item name */
627:
628: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
629: SET assembly_item_number = (SELECT concatenated_segments
630: FROM MTL_SYSTEM_ITEMS_KFV mvl1
631: WHERE mvl1.inventory_item_id = BICI.assembly_item_id
632: AND mvl1.organization_id = BICI.organization_id)

Line 650: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

646:
647: stmt_num := 5.1;
648: /* Update the Assembly Item Id */
649:
650: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
651: SET assembly_item_id = (SELECT inventory_item_id
652: FROM MTL_SYSTEM_ITEMS_KFV mvl1
653: WHERE mvl1.concatenated_segments = BICI.assembly_item_number
654: AND mvl1.organization_id = BICI.organization_id)

Line 670: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

666:
667: stmt_num := 6;
668: /* Update Component Item name */
669:
670: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
671: SET component_item_number = (SELECT CONCATENATED_SEGMENTS
672: FROM MTL_SYSTEM_ITEMS_KFV mvl1
673: WHERE mvl1.inventory_item_id = BICI.component_item_id
674: AND mvl1.organization_id = BICI.organization_id)

Line 691: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

687: AND mvl12.organization_id = BICI.organization_id);
688:
689: stmt_num := 6.1;
690: /* Update the component_item_id */
691: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
692: SET component_item_id = (SELECT inventory_item_id
693: FROM mtl_system_items_kfv mvll
694: WHERE mvll.concatenated_segments = BICI.component_item_number
695: AND mvll.organization_id = BICI.organization_id)

Line 711: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

707:
708: stmt_num := 7;
709: /* Assign transaction ids */
710:
711: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
712: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
713: transaction_type = upper(transaction_type)
714: WHERE transaction_id is null
715: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 730: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

726:
727: stmt_num := 8;
728: /* Update Supply_locator_name */
729:
730: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
731: SET location_name = (SELECT concatenated_segments
732: FROM MTL_ITEM_LOCATIONS_KFV MIL1
733: WHERE MIL1.inventory_location_id = BICI.supply_locator_id
734: and MIL1.organization_id = BICI.organization_id)

Line 751: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

747: and mil2.organization_id = BICI.organization_id);
748:
749: stmt_num := 8.5;
750: /* Update the delete_group_name from bom_interface_delete_groups */
751: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
752: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
753: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
754: FROM bom_interface_delete_groups
755: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'

Line 755: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'

751: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
752: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
753: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
754: FROM bom_interface_delete_groups
755: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
756: And rownum = 1)
757: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
758: AND upper(transaction_type) in (G_Delete)
759: AND organization_id is not null

Line 768: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'

764: OR ( p_batch_id = BICI.batch_id )
765: )
766: AND exists (SELECT 'x'
767: FROM bom_interface_delete_groups
768: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
769: );
770:
771:
772: stmt_num := 8.6;

Line 774: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

770:
771:
772: stmt_num := 8.6;
773: /* Update the bill_sequence_id */
774: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
775: SET bill_sequence_id = (SELECT bill_sequence_id
776: FROM bom_structures_b bom
777: WHERE bom.assembly_item_id = BICI.assembly_item_id
778: AND bom.organization_id = BICI.organization_id

Line 800: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

796:
797:
798: stmt_num := 8.8;
799: /* Update the component_sequence_id */
800: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
801: SET COMPONENT_SEQUENCE_ID
802: = (SELECT COMPONENT_SEQUENCE_ID
803: FROM bom_components_b BIC
804: Where BIC.bill_sequence_id = BICI.bill_Sequence_id

Line 822: UPDATE BOM_INVENTORY_COMPS_INTERFACE

818:
819: stmt_num := 8.9;
820: /* Defaulting the effectivity_date to sysdate if the transaction_type is create
821: and effectivity date is null */
822: UPDATE BOM_INVENTORY_COMPS_INTERFACE
823: SET EFFECTIVITY_DATE = SYSDATE
824: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
825: AND upper(Transaction_Type) = G_Create
826: AND Effectivity_Date IS NULL

Line 891: FROM bom_inventory_comps_interface

887: COMPONENT_ITEM_NUMBER,
888: ASSEMBLY_ITEM_NUMBER,
889: FROM_END_ITEM_UNIT_NUMBER,
890: BATCH_ID
891: FROM bom_inventory_comps_interface
892: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
893: AND transaction_type = G_Create
894: AND (all_org = 1
895: OR

Line 963: FROM bom_inventory_comps_interface

959: EFFECTIVITY_DATE,
960: OPERATION_SEQ_NUM,
961: FROM_END_ITEM_UNIT_NUMBER,
962: BATCH_ID
963: FROM bom_inventory_comps_interface
964: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
965: AND transaction_type = G_Create
966: AND (all_org = 1
967: OR

Line 1013: 'BOM_INVENTORY_COMPS_INTERFACE',

1009: BICI.transaction_id,
1010: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1011: Null,
1012: null,
1013: 'BOM_INVENTORY_COMPS_INTERFACE',
1014: decode ( BICI.Organization_code, null, msg_name1,msg_name2),
1015: decode ( BICI.Organization_code, null, msg_text1,msg_text2),
1016: NVL(LAST_UPDATE_DATE, SYSDATE),
1017: NVL(LAST_UPDATED_BY, user_id),

Line 1026: from BOM_INVENTORY_COMPS_INTERFACE BICI

1022: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1023: NVL(PROGRAM_ID, prog_id),
1024: NVL(PROGRAM_UPDATE_DATE, sysdate)
1025:
1026: from BOM_INVENTORY_COMPS_INTERFACE BICI
1027: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1028: and transaction_id is not null
1029: and process_flag =1
1030: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 1039: Update BOM_INVENTORY_COMPS_INTERFACE

1035: );
1036:
1037:
1038:
1039: Update BOM_INVENTORY_COMPS_INTERFACE
1040: set process_flag = 3
1041: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1042: and transaction_id is not null
1043: and process_flag =1

Line 1603: 'BOM_INVENTORY_COMPS_INTERFACE',

1599: BSCI.transaction_id,
1600: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1601: Null,
1602: null,
1603: 'BOM_INVENTORY_COMPS_INTERFACE',
1604: decode ( BSCI.Organization_code, null, msg_name1,msg_name2),
1605: decode ( BSCI.Organization_code, null, msg_text1,msg_text2),
1606: NVL(LAST_UPDATE_DATE, SYSDATE),
1607: NVL(LAST_UPDATED_BY, user_id),

Line 2197: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Update

2193: AND mrb.organization_id = BBMI.organization_id
2194: AND mrb.revision = BBMI.Revision);
2195:
2196: /* If SYNC rows has valid ComponentSequenceId then update the transaction type to UPDATE */
2197: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Update
2198: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2199: AND UPPER(transaction_type) = 'SYNC'
2200: AND component_sequence_id IS NOT NULL
2201: AND

Line 2211: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create

2207: FROM BOM_INVENTORY_COMPONENTS BIC2
2208: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2209:
2210: /* If SYNC rows don't have ComponentSequenceId value then update the transaction type to CREATE */
2211: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create
2212: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2213: AND UPPER(transaction_type) = 'SYNC'
2214: AND component_sequence_id IS NULL
2215: AND

Line 2224: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2220:
2221: /* Update Organization_ids if organization_code is given org id is null.
2222: Orgnaization_id information is needed in the next steps */
2223:
2224: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2225: SET organization_id = (SELECT organization_id
2226: FROM MTL_PARAMETERS mp1
2227: WHERE mp1.organization_code = BICI.organization_code)
2228: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2237: FROM MTL_PARAMETERS mp2
2238: WHERE mp2.organization_code = BICI.organization_code);
2239:
2240: /* Update the Assembly_item_number */
2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2242: SET assembly_item_number = (SELECT concatenated_segments
2243: FROM mtl_system_items_kfv MKFV
2244: WHERE MKFV.inventory_item_id = BICI.Assembly_item_id
2245: AND MKFV.organization_id = BICI.organization_id)

Line 2263: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2259:
2260:
2261:
2262: /* Update the Assembly_item_id */
2263: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2264: SET Assembly_item_id = (SELECT inventory_item_id
2265: FROM mtl_system_items_kfv mvll
2266: WHERE mvll.concatenated_segments = BICI.Assembly_item_number
2267: AND mvll.organization_id = BICI.organization_id)

Line 2280: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2276: OR ( p_batch_id = BICI.batch_id )
2277: );
2278:
2279: /* Update component_item_number */
2280: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2281: SET component_item_number = (SELECT concatenated_segments
2282: FROM mtl_system_items_kfv mvll
2283: WHERE mvll.inventory_item_id = BICI.Component_item_id
2284: AND mvll.organization_id = BICI.organization_id)

Line 2300: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2296: WHERE MKFV.inventory_item_id = BICI.Component_item_id
2297: AND MKFV.organization_id = BICI.organization_id);
2298:
2299: /* Update the component_item_id */
2300: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2301: SET component_item_id = (SELECT inventory_item_id
2302: FROM mtl_system_items_kfv mvll
2303: WHERE mvll.concatenated_segments = BICI.Component_item_number
2304: AND mvll.organization_id = BICI.organization_id)

Line 2317: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2313: OR ( p_batch_id = BICI.batch_id )
2314: );
2315:
2316: /* Update the bill_sequence_id */
2317: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2318: SET bill_sequence_id = (SELECT bill_sequence_id
2319: FROM bom_structures_b bom
2320: WHERE bom.assembly_item_id = BICI.assembly_item_id
2321: AND bom.organization_id = BICI.organization_id

Line 2356: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2352: END IF;
2353: */
2354: /* Resolve the Component_sequence_ids for updates and deletes */
2355:
2356: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2357: SET(component_item_id, effectivity_date,
2358: operation_seq_num, from_end_item_unit_number)
2359: = (SELECT component_item_id,
2360: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 2377: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2373: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2374:
2375:
2376: /* Update the component_sequence_id */
2377: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2378: SET COMPONENT_SEQUENCE_ID
2379: = (SELECT COMPONENT_SEQUENCE_ID
2380: FROM BOM_INVENTORY_COMPONENTS BIC
2381: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id

Line 2405: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2401:
2402:
2403:
2404: /* Update the From_end_item_id */
2405: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2406: SET From_End_Item_id = (SELECT inventory_item_id
2407: FROM mtl_system_items_kfv mvll
2408: WHERE mvll.concatenated_segments = BICI.From_End_Item
2409: AND mvll.organization_id = BICI.organization_id)

Line 2425: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2421: WHERE mvll2.concatenated_segments = BICI.From_End_Item
2422: AND mvll2.organization_id = BICI.organization_id);
2423:
2424: /* Update the From_end_item_rev_id */
2425: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2426: SET From_end_item_rev_id = (SELECT mrb.revision_id
2427: FROM mtl_item_revisions_b mrb
2428: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2429: AND mrb.organization_id = BICI.organization_id

Line 2448: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2444: AND mrb.organization_id = BICI.organization_id
2445: AND mrb.revision = BICI.From_end_item_rev_code);
2446:
2447: /* Update the To_end_item_rev_id */
2448: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2449: SET To_end_item_rev_id = (SELECT mrb.revision_id
2450: FROM mtl_item_revisions_b mrb
2451: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2452: AND mrb.organization_id = BICI.organization_id

Line 2471: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2467: AND mrb.organization_id = BICI.organization_id
2468: AND mrb.revision = BICI.To_end_item_rev_code);
2469:
2470: /* Update the component_revision_id */
2471: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2472: SET Component_revision_id = (SELECT mrb.revision_id
2473: FROM mtl_item_revisions_b mrb
2474: WHERE mrb.inventory_item_id = BICI.component_item_id
2475: AND mrb.organization_id = BICI.organization_id

Line 2494: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2490: AND mrb.organization_id = BICI.organization_id
2491: AND mrb.revision = BICI.Component_revision_code);
2492:
2493: /* Update the assembly items pk3 value */
2494: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2495: SET Parent_Revision_Id = (SELECT mrb.revision_id
2496: FROM mtl_item_revisions_b mrb
2497: WHERE mrb.inventory_item_id = BICI.Assembly_item_id
2498: AND mrb.organization_id = BICI.organization_id

Line 2514: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2510:
2511:
2512: /* Update Supply_locator_name */
2513:
2514: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2515: SET supply_locator_id = (SELECT inventory_location_id
2516: FROM MTL_ITEM_LOCATIONS_KFV MIL1
2517: WHERE MIL1.concatenated_segments = BICI.location_name
2518: AND MIL1.organization_id = BICI.organization_id)

Line 2533: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2529: FROM MTL_ITEM_LOCATIONS_KFV mil2
2530: WHERE mil2.concatenated_segments = BICI.location_name
2531: AND mil2.organization_id = BICI.organization_id);
2532:
2533: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2534: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2535: transaction_type = upper(transaction_type)
2536: WHERE transaction_id is null
2537: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)