DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on CST_LOW_LEVEL_CODES

Line 1980: INSERT INTO CST_LOW_LEVEL_CODES

1976: ** just performed
1977: */
1978: stmt_num := 5;
1979:
1980: INSERT INTO CST_LOW_LEVEL_CODES
1981: (ROLLUP_ID, INVENTORY_ITEM_ID, LOW_LEVEL_CODE,
1982: LAST_UPDATE_DATE, LAST_UPDATED_BY,
1983: CREATION_DATE, CREATED_BY)
1984:

Line 1998: DELETE CST_LOW_LEVEL_CODES CLLC

1994:
1995: IF (rollup_option = 1) THEN
1996: stmt_num := 6;
1997:
1998: DELETE CST_LOW_LEVEL_CODES CLLC
1999: WHERE NOT EXISTS (SELECT 'Item in list'
2000: FROM BOM_LISTS BL
2001: WHERE SEQUENCE_ID = list_id
2002: AND BL.ASSEMBLY_ITEM_ID = CLLC.INVENTORY_ITEM_ID)

Line 2048: /* delete from cst_low_level_codes

2044: --commented for bug 5322048.
2045: /*
2046: ** delete low level codes
2047: */
2048: /* delete from cst_low_level_codes
2049: where rollup_id = cst_rlp_id;
2050: */
2051: END IF;
2052: