APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_EXPLOSIONS

Line 333: FROM BOM_EXPLOSIONS be,

329: be.effectivity_date,
330: be.disable_date,
331: be.implementation_date,
332: bic.wip_supply_type
333: FROM BOM_EXPLOSIONS be,
334: bom_inventory_components bic
335: WHERE be.TOP_BILL_SEQUENCE_ID = X_Top_Bill_Sequence_Id
336: AND be.ORGANIZATION_ID = X_Organization_Id
337: AND be.EXPLOSION_TYPE = 'OPTIONAL'

Line 3245: FROM bom_explosions be

3241: SYSDATE,
3242: NULL /*Disable_Date*/,
3243: SYSDATE, /* Implementation Date */
3244: 6 /* wip_supply_type */
3245: FROM bom_explosions be
3246: WHERE be.top_bill_sequence_id = X_top_Bill_Sequence_id
3247: AND be.explosion_type = 'OPTIONAL'
3248: AND be.effectivity_date <= SYSDATE
3249: AND nvl(be.disable_date,SYSDATE+1) > SYSDATE