APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ABC_ASSIGNMENTS

Line 272: | Inserted the configuration data into table MTL_ABC_ASSIGNMENTS

268: | ssawant 15-JAN-04 Bugfix 3379296
269: | changes evaluate_atp_attributes for model attribute Y, N scenario.
270: |
271: | KKONADA 02-03-2004 bugfix 2828588
272: | Inserted the configuration data into table MTL_ABC_ASSIGNMENTS
273: |
274: |
275: |
276: | KKONADA 03-02-2004 front port bugfix#3473737

Line 8182: INSERT INTO mtl_abc_assignments

8178:
8179: --satrt bugfix 2828588
8180: --added for 11.5.10 , patchset-J
8181: lStmtNumber := 310;
8182: INSERT INTO mtl_abc_assignments
8183: (
8184: inventory_item_id,
8185: assignment_group_id,
8186: abc_class_id,

Line 8199: FROM mtl_abc_assignments maa

8195: sysdate,
8196: gUserId,
8197: sysdate,
8198: gUserId
8199: FROM mtl_abc_assignments maa
8200: WHERE maa.inventory_item_id = pModelId
8201: --bugfix3536085 not exists condition
8202: AND NOT EXISTS
8203: (SELECT 'X'

Line 8204: FROM mtl_abc_assignments

8200: WHERE maa.inventory_item_id = pModelId
8201: --bugfix3536085 not exists condition
8202: AND NOT EXISTS
8203: (SELECT 'X'
8204: FROM mtl_abc_assignments
8205: WHERE inventory_item_id = pConfigId
8206: AND assignment_group_id = maa.assignment_group_id );
8207:
8208:

Line 8215: oe_debug_pub.add('Create_Item: ' || 'inserted '||sql%rowcount||' in mtl_abc_assignments',2);

8211:
8212:
8213: IF PG_DEBUG <> 0 THEN
8214:
8215: oe_debug_pub.add('Create_Item: ' || 'inserted '||sql%rowcount||' in mtl_abc_assignments',2);
8216:
8217: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_abc_assignments',2);
8218: END IF;
8219:

Line 8217: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_abc_assignments',2);

8213: IF PG_DEBUG <> 0 THEN
8214:
8215: oe_debug_pub.add('Create_Item: ' || 'inserted '||sql%rowcount||' in mtl_abc_assignments',2);
8216:
8217: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_abc_assignments',2);
8218: END IF;
8219:
8220: --end bugfix 2828588
8221: