DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on CST_LOW_LEVEL_CODES

Line 2001: INSERT INTO CST_LOW_LEVEL_CODES

1997: ** just performed
1998: */
1999: stmt_num := 5;
2000:
2001: INSERT INTO CST_LOW_LEVEL_CODES
2002: (ROLLUP_ID, INVENTORY_ITEM_ID, LOW_LEVEL_CODE,
2003: LAST_UPDATE_DATE, LAST_UPDATED_BY,
2004: CREATION_DATE, CREATED_BY)
2005:

Line 2019: DELETE CST_LOW_LEVEL_CODES CLLC

2015:
2016: IF (rollup_option = 1) THEN
2017: stmt_num := 6;
2018:
2019: DELETE CST_LOW_LEVEL_CODES CLLC
2020: WHERE NOT EXISTS (SELECT 'Item in list'
2021: FROM BOM_LISTS BL
2022: WHERE SEQUENCE_ID = list_id
2023: AND BL.ASSEMBLY_ITEM_ID = CLLC.INVENTORY_ITEM_ID)

Line 2069: /* delete from cst_low_level_codes

2065: --commented for bug 5322048.
2066: /*
2067: ** delete low level codes
2068: */
2069: /* delete from cst_low_level_codes
2070: where rollup_id = cst_rlp_id;
2071: */
2072: END IF;
2073: