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 7997: INSERT INTO mtl_abc_assignments

7993:
7994: --satrt bugfix 2828588
7995: --added for 11.5.10 , patchset-J
7996: lStmtNumber := 310;
7997: INSERT INTO mtl_abc_assignments
7998: (
7999: inventory_item_id,
8000: assignment_group_id,
8001: abc_class_id,

Line 8014: FROM mtl_abc_assignments maa

8010: sysdate,
8011: gUserId,
8012: sysdate,
8013: gUserId
8014: FROM mtl_abc_assignments maa
8015: WHERE maa.inventory_item_id = pModelId
8016: --bugfix3536085 not exists condition
8017: AND NOT EXISTS
8018: (SELECT 'X'

Line 8019: FROM mtl_abc_assignments

8015: WHERE maa.inventory_item_id = pModelId
8016: --bugfix3536085 not exists condition
8017: AND NOT EXISTS
8018: (SELECT 'X'
8019: FROM mtl_abc_assignments
8020: WHERE inventory_item_id = pConfigId
8021: AND assignment_group_id = maa.assignment_group_id );
8022:
8023:

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

8026:
8027:
8028: IF PG_DEBUG <> 0 THEN
8029:
8030: oe_debug_pub.add('Create_Item: ' || 'inserted '||sql%rowcount||' in mtl_abc_assignments',2);
8031:
8032: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_abc_assignments',2);
8033: END IF;
8034:

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

8028: IF PG_DEBUG <> 0 THEN
8029:
8030: oe_debug_pub.add('Create_Item: ' || 'inserted '||sql%rowcount||' in mtl_abc_assignments',2);
8031:
8032: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_abc_assignments',2);
8033: END IF;
8034:
8035: --end bugfix 2828588
8036: