APPS.BOM_OPEN_INTERFACE_UTL dependencies on MTL_ITEM_REVISIONS_B

Line 2181: FROM mtl_item_revisions_b mrb

2177:
2178: /* Set PK3_value if the value for revision exists */
2179: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
2180: SET pk3_value = (SELECT mrb.revision_id
2181: FROM mtl_item_revisions_b mrb
2182: WHERE mrb.inventory_item_id = BBMI.Assembly_item_id
2183: AND mrb.organization_id = BBMI.organization_id
2184: AND mrb.revision = BBMI.REVISION)
2185: WHERE process_flag = 1

Line 2191: FROM mtl_item_revisions_b mrb

2187: AND Assembly_item_id is not null
2188: AND Revision is not null
2189: AND organization_id is not null
2190: AND exists (SELECT 1
2191: FROM mtl_item_revisions_b mrb
2192: WHERE mrb.inventory_item_id = BBMI.Assembly_item_id
2193: AND mrb.organization_id = BBMI.organization_id
2194: AND mrb.revision = BBMI.Revision);
2195:

Line 2427: FROM mtl_item_revisions_b mrb

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

Line 2442: FROM mtl_item_revisions_b mrb

2438: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2439: OR ( p_batch_id = BICI.batch_id )
2440: )
2441: AND exists (SELECT 1
2442: FROM mtl_item_revisions_b mrb
2443: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2444: AND mrb.organization_id = BICI.organization_id
2445: AND mrb.revision = BICI.From_end_item_rev_code);
2446:

Line 2450: FROM mtl_item_revisions_b mrb

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

Line 2465: FROM mtl_item_revisions_b mrb

2461: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2462: OR ( p_batch_id = BICI.batch_id )
2463: )
2464: AND exists (SELECT 1
2465: FROM mtl_item_revisions_b mrb
2466: WHERE mrb.inventory_item_id = BICI.From_End_Item_id
2467: AND mrb.organization_id = BICI.organization_id
2468: AND mrb.revision = BICI.To_end_item_rev_code);
2469:

Line 2473: FROM mtl_item_revisions_b mrb

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

Line 2488: FROM mtl_item_revisions_b mrb

2484: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2485: OR ( p_batch_id = BICI.batch_id )
2486: )
2487: AND exists (SELECT 1
2488: FROM mtl_item_revisions_b mrb
2489: WHERE mrb.inventory_item_id = BICI.component_item_id
2490: AND mrb.organization_id = BICI.organization_id
2491: AND mrb.revision = BICI.Component_revision_code);
2492:

Line 2496: FROM mtl_item_revisions_b mrb

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

Line 2753: FROM mtl_item_revisions_b mrb

2749:
2750:
2751: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2752: SET Assembly_Item_Revision_Id = (SELECT mrb.revision_id
2753: FROM mtl_item_revisions_b mrb
2754: WHERE mrb.inventory_item_id = BRDI.Assembly_item_id
2755: AND mrb.organization_id = BRDI.organization_id
2756: AND mrb.revision = BRDI.Assembly_Item_Revision_Code)
2757: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import