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 566: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

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

Line 589: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

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

Line 612: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

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

Line 632: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

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

Line 655: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

651:
652: stmt_num := 5.1;
653: /* Update the Assembly Item Id */
654:
655: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
656: SET assembly_item_id = (SELECT inventory_item_id
657: FROM MTL_SYSTEM_ITEMS_KFV mvl1
658: WHERE mvl1.concatenated_segments = BICI.assembly_item_number
659: AND mvl1.organization_id = BICI.organization_id)

Line 676: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

672:
673: stmt_num := 6;
674: /* Update Component Item name */
675:
676: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
677: SET component_item_number = (SELECT CONCATENATED_SEGMENTS
678: FROM MTL_SYSTEM_ITEMS_KFV mvl1
679: WHERE mvl1.inventory_item_id = BICI.component_item_id
680: AND mvl1.organization_id = BICI.organization_id)

Line 698: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

694: AND mvl12.organization_id = BICI.organization_id);
695:
696: stmt_num := 6.1;
697: /* Update the component_item_id */
698: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
699: SET component_item_id = (SELECT inventory_item_id
700: FROM mtl_system_items_kfv mvll
701: WHERE mvll.concatenated_segments = BICI.component_item_number
702: AND mvll.organization_id = BICI.organization_id)

Line 719: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

715:
716: stmt_num := 7;
717: /* Assign transaction ids */
718:
719: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
720: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
721: transaction_type = upper(transaction_type)
722: WHERE transaction_id is null
723: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 739: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

735:
736: stmt_num := 8;
737: /* Update Supply_locator_name */
738:
739: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
740: SET location_name = (SELECT concatenated_segments
741: FROM MTL_ITEM_LOCATIONS_KFV MIL1
742: WHERE MIL1.inventory_location_id = BICI.supply_locator_id
743: and MIL1.organization_id = BICI.organization_id)

Line 761: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

757: and mil2.organization_id = BICI.organization_id);
758:
759: stmt_num := 8.5;
760: /* Update the delete_group_name from bom_interface_delete_groups */
761: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
762: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
763: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
764: FROM bom_interface_delete_groups
765: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'

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

761: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
762: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
763: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
764: FROM bom_interface_delete_groups
765: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
766: And rownum = 1)
767: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
768: AND change_notice is null --added for bug 9673701
769: AND upper(transaction_type) in (G_Delete)

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

775: OR ( p_batch_id = BICI.batch_id )
776: )
777: AND exists (SELECT 'x'
778: FROM bom_interface_delete_groups
779: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
780: );
781:
782:
783: stmt_num := 8.6;

Line 785: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

781:
782:
783: stmt_num := 8.6;
784: /* Update the bill_sequence_id */
785: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
786: SET bill_sequence_id = (SELECT bill_sequence_id
787: FROM bom_structures_b bom
788: WHERE bom.assembly_item_id = BICI.assembly_item_id
789: AND bom.organization_id = BICI.organization_id

Line 812: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

808:
809:
810: stmt_num := 8.8;
811: /* Update the component_sequence_id */
812: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
813: SET COMPONENT_SEQUENCE_ID
814: = (SELECT COMPONENT_SEQUENCE_ID
815: FROM bom_components_b BIC
816: Where BIC.bill_sequence_id = BICI.bill_Sequence_id

Line 835: UPDATE BOM_INVENTORY_COMPS_INTERFACE

831:
832: stmt_num := 8.9;
833: /* Defaulting the effectivity_date to sysdate if the transaction_type is create
834: and effectivity date is null */
835: UPDATE BOM_INVENTORY_COMPS_INTERFACE
836: SET EFFECTIVITY_DATE = SYSDATE
837: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
838: AND change_notice is null --added for bug 9673701
839: AND upper(Transaction_Type) = G_Create

Line 905: FROM bom_inventory_comps_interface

901: COMPONENT_ITEM_NUMBER,
902: ASSEMBLY_ITEM_NUMBER,
903: FROM_END_ITEM_UNIT_NUMBER,
904: BATCH_ID
905: FROM bom_inventory_comps_interface
906: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
907: AND change_notice is null --added for bug 9673701
908: AND transaction_type = G_Create
909: AND (all_org = 1

Line 978: FROM bom_inventory_comps_interface

974: EFFECTIVITY_DATE,
975: OPERATION_SEQ_NUM,
976: FROM_END_ITEM_UNIT_NUMBER,
977: BATCH_ID
978: FROM bom_inventory_comps_interface
979: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
980: AND change_notice is null --added for bug 9673701
981: AND transaction_type = G_Create
982: AND (all_org = 1

Line 1029: 'BOM_INVENTORY_COMPS_INTERFACE',

1025: BICI.transaction_id,
1026: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1027: Null,
1028: null,
1029: 'BOM_INVENTORY_COMPS_INTERFACE',
1030: decode ( BICI.Organization_code, null, msg_name1,msg_name2),
1031: decode ( BICI.Organization_code, null, msg_text1,msg_text2),
1032: NVL(LAST_UPDATE_DATE, SYSDATE),
1033: NVL(LAST_UPDATED_BY, user_id),

Line 1042: from BOM_INVENTORY_COMPS_INTERFACE BICI

1038: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1039: NVL(PROGRAM_ID, prog_id),
1040: NVL(PROGRAM_UPDATE_DATE, sysdate)
1041:
1042: from BOM_INVENTORY_COMPS_INTERFACE BICI
1043: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1044: and transaction_id is not null
1045: and process_flag =1
1046: AND change_notice is null --added for bug 9673701

Line 1056: Update BOM_INVENTORY_COMPS_INTERFACE

1052: );
1053:
1054:
1055:
1056: Update BOM_INVENTORY_COMPS_INTERFACE
1057: set process_flag = 3
1058: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1059: and transaction_id is not null
1060: and process_flag =1

Line 1639: 'BOM_INVENTORY_COMPS_INTERFACE',

1635: BSCI.transaction_id,
1636: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1637: Null,
1638: null,
1639: 'BOM_INVENTORY_COMPS_INTERFACE',
1640: decode ( BSCI.Organization_code, null, msg_name1,msg_name2),
1641: decode ( BSCI.Organization_code, null, msg_text1,msg_text2),
1642: NVL(LAST_UPDATE_DATE, SYSDATE),
1643: NVL(LAST_UPDATED_BY, user_id),

Line 2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Update

2237: AND mrb.organization_id = BBMI.organization_id
2238: AND mrb.revision = BBMI.Revision);
2239:
2240: /* If SYNC rows has valid ComponentSequenceId then update the transaction type to UPDATE */
2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Update
2242: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2243: AND UPPER(transaction_type) = 'SYNC'
2244: AND component_sequence_id IS NOT NULL
2245: AND

Line 2255: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create

2251: FROM BOM_INVENTORY_COMPONENTS BIC2
2252: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2253:
2254: /* If SYNC rows don't have ComponentSequenceId value then update the transaction type to CREATE */
2255: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create
2256: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2257: AND UPPER(transaction_type) = 'SYNC'
2258: AND component_sequence_id IS NULL
2259: AND

Line 2268: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2264:
2265: /* Update Organization_ids if organization_code is given org id is null.
2266: Orgnaization_id information is needed in the next steps */
2267:
2268: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2269: SET organization_id = (SELECT organization_id
2270: FROM MTL_PARAMETERS mp1
2271: WHERE mp1.organization_code = BICI.organization_code)
2272: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2285: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2281: FROM MTL_PARAMETERS mp2
2282: WHERE mp2.organization_code = BICI.organization_code);
2283:
2284: /* Update the Assembly_item_number */
2285: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2286: SET assembly_item_number = (SELECT concatenated_segments
2287: FROM mtl_system_items_kfv MKFV
2288: WHERE MKFV.inventory_item_id = BICI.Assembly_item_id
2289: AND MKFV.organization_id = BICI.organization_id)

Line 2307: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2303:
2304:
2305:
2306: /* Update the Assembly_item_id */
2307: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2308: SET Assembly_item_id = (SELECT inventory_item_id
2309: FROM mtl_system_items_kfv mvll
2310: WHERE mvll.concatenated_segments = BICI.Assembly_item_number
2311: AND mvll.organization_id = BICI.organization_id)

Line 2324: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2320: OR ( p_batch_id = BICI.batch_id )
2321: );
2322:
2323: /* Update component_item_number */
2324: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2325: SET component_item_number = (SELECT concatenated_segments
2326: FROM mtl_system_items_kfv mvll
2327: WHERE mvll.inventory_item_id = BICI.Component_item_id
2328: AND mvll.organization_id = BICI.organization_id)

Line 2344: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2340: WHERE MKFV.inventory_item_id = BICI.Component_item_id
2341: AND MKFV.organization_id = BICI.organization_id);
2342:
2343: /* Update the component_item_id */
2344: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2345: SET component_item_id = (SELECT inventory_item_id
2346: FROM mtl_system_items_kfv mvll
2347: WHERE mvll.concatenated_segments = BICI.Component_item_number
2348: AND mvll.organization_id = BICI.organization_id)

Line 2361: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2357: OR ( p_batch_id = BICI.batch_id )
2358: );
2359:
2360: /* Update the bill_sequence_id */
2361: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2362: SET bill_sequence_id = (SELECT bill_sequence_id
2363: FROM bom_structures_b bom
2364: WHERE bom.assembly_item_id = BICI.assembly_item_id
2365: AND bom.organization_id = BICI.organization_id

Line 2400: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2396: END IF;
2397: */
2398: /* Resolve the Component_sequence_ids for updates and deletes */
2399:
2400: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2401: SET(component_item_id, effectivity_date,
2402: operation_seq_num, from_end_item_unit_number)
2403: = (SELECT component_item_id,
2404: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 2421: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2417: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2418:
2419:
2420: /* Update the component_sequence_id */
2421: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2422: SET COMPONENT_SEQUENCE_ID
2423: = (SELECT COMPONENT_SEQUENCE_ID
2424: FROM BOM_INVENTORY_COMPONENTS BIC
2425: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id

Line 2449: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2445:
2446:
2447:
2448: /* Update the From_end_item_id */
2449: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2450: SET From_End_Item_id = (SELECT inventory_item_id
2451: FROM mtl_system_items_kfv mvll
2452: WHERE mvll.concatenated_segments = BICI.From_End_Item
2453: AND mvll.organization_id = BICI.organization_id)

Line 2469: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2465: WHERE mvll2.concatenated_segments = BICI.From_End_Item
2466: AND mvll2.organization_id = BICI.organization_id);
2467:
2468: /* Update the From_end_item_rev_id */
2469: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2470: SET From_end_item_rev_id = (SELECT mrb.revision_id
2471: FROM mtl_item_revisions_b mrb
2472: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2473: AND mrb.organization_id = BICI.organization_id

Line 2492: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2488: AND mrb.organization_id = BICI.organization_id
2489: AND mrb.revision = BICI.From_end_item_rev_code);
2490:
2491: /* Update the To_end_item_rev_id */
2492: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2493: SET To_end_item_rev_id = (SELECT mrb.revision_id
2494: FROM mtl_item_revisions_b mrb
2495: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2496: AND mrb.organization_id = BICI.organization_id

Line 2515: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2511: AND mrb.organization_id = BICI.organization_id
2512: AND mrb.revision = BICI.To_end_item_rev_code);
2513:
2514: /* Update the component_revision_id */
2515: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2516: SET Component_revision_id = (SELECT mrb.revision_id
2517: FROM mtl_item_revisions_b mrb
2518: WHERE mrb.inventory_item_id = BICI.component_item_id
2519: AND mrb.organization_id = BICI.organization_id

Line 2538: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2534: AND mrb.organization_id = BICI.organization_id
2535: AND mrb.revision = BICI.Component_revision_code);
2536:
2537: /* Update the assembly items pk3 value */
2538: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2539: SET Parent_Revision_Id = (SELECT mrb.revision_id
2540: FROM mtl_item_revisions_b mrb
2541: WHERE mrb.inventory_item_id = BICI.Assembly_item_id
2542: AND mrb.organization_id = BICI.organization_id

Line 2558: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2554:
2555:
2556: /* Update Supply_locator_name */
2557:
2558: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2559: SET supply_locator_id = (SELECT inventory_location_id
2560: FROM MTL_ITEM_LOCATIONS_KFV MIL1
2561: WHERE MIL1.concatenated_segments = BICI.location_name
2562: AND MIL1.organization_id = BICI.organization_id)

Line 2577: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

2573: FROM MTL_ITEM_LOCATIONS_KFV mil2
2574: WHERE mil2.concatenated_segments = BICI.location_name
2575: AND mil2.organization_id = BICI.organization_id);
2576:
2577: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2578: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2579: transaction_type = upper(transaction_type)
2580: WHERE transaction_id is null
2581: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)