APPS.BOM_OPEN_INTERFACE_UTL dependencies on MTL_ITEM_REVISIONS_B

Line 2225: FROM mtl_item_revisions_b mrb

2221:
2222: /* Set PK3_value if the value for revision exists */
2223: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
2224: SET pk3_value = (SELECT mrb.revision_id
2225: FROM mtl_item_revisions_b mrb
2226: WHERE mrb.inventory_item_id = BBMI.Assembly_item_id
2227: AND mrb.organization_id = BBMI.organization_id
2228: AND mrb.revision = BBMI.REVISION)
2229: WHERE process_flag = 1

Line 2235: FROM mtl_item_revisions_b mrb

2231: AND Assembly_item_id is not null
2232: AND Revision is not null
2233: AND organization_id is not null
2234: AND exists (SELECT 1
2235: FROM mtl_item_revisions_b mrb
2236: WHERE mrb.inventory_item_id = BBMI.Assembly_item_id
2237: AND mrb.organization_id = BBMI.organization_id
2238: AND mrb.revision = BBMI.Revision);
2239:

Line 2471: FROM mtl_item_revisions_b mrb

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
2474: AND mrb.revision = BICI.From_end_item_rev_code)
2475: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2486: FROM mtl_item_revisions_b mrb

2482: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2483: OR ( p_batch_id = BICI.batch_id )
2484: )
2485: AND exists (SELECT 1
2486: FROM mtl_item_revisions_b mrb
2487: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2488: AND mrb.organization_id = BICI.organization_id
2489: AND mrb.revision = BICI.From_end_item_rev_code);
2490:

Line 2494: FROM mtl_item_revisions_b mrb

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
2497: AND mrb.revision = BICI.To_end_item_rev_code)
2498: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2509: FROM mtl_item_revisions_b mrb

2505: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2506: OR ( p_batch_id = BICI.batch_id )
2507: )
2508: AND exists (SELECT 1
2509: FROM mtl_item_revisions_b mrb
2510: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2511: AND mrb.organization_id = BICI.organization_id
2512: AND mrb.revision = BICI.To_end_item_rev_code);
2513:

Line 2517: FROM mtl_item_revisions_b mrb

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
2520: AND mrb.revision = BICI.Component_revision_code)
2521: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2532: FROM mtl_item_revisions_b mrb

2528: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2529: OR ( p_batch_id = BICI.batch_id )
2530: )
2531: AND exists (SELECT 1
2532: FROM mtl_item_revisions_b mrb
2533: WHERE mrb.inventory_item_id = BICI.component_item_id
2534: AND mrb.organization_id = BICI.organization_id
2535: AND mrb.revision = BICI.Component_revision_code);
2536:

Line 2540: FROM mtl_item_revisions_b mrb

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
2543: AND mrb.revision = BICI.Parent_revision_code)
2544: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2797: FROM mtl_item_revisions_b mrb

2793:
2794:
2795: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2796: SET Assembly_Item_Revision_Id = (SELECT mrb.revision_id
2797: FROM mtl_item_revisions_b mrb
2798: WHERE mrb.inventory_item_id = BRDI.Assembly_item_id
2799: AND mrb.organization_id = BRDI.organization_id
2800: AND mrb.revision = BRDI.Assembly_Item_Revision_Code)
2801: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import