APPS.GMF_MIGRATION dependencies on CM_CMPT_MTL

Line 9627: FROM cm_cmpt_mtl a,

9623: organization_id
9624: FROM (
9625: SELECT a.item_id,
9626: decode(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
9627: FROM cm_cmpt_mtl a,
9628: sy_orgn_mst b,
9629: ic_whse_mst c
9630: WHERE a.item_id IS NOT NULL
9631: AND a.co_code = b.co_code

Line 9639: G_Table_name := 'CM_CMPT_MTL';

9635:
9636: BEGIN
9637:
9638: G_Migration_run_id := P_migration_run_id;
9639: G_Table_name := 'CM_CMPT_MTL';
9640: G_Context := 'Material Cost Components Migration';
9641: X_failure_count := 0;
9642:
9643: /********************************

Line 9685: UPDATE cm_cmpt_mtl a

9681: /*****************************************
9682: * Update rows For Legal Entity and Item *
9683: *****************************************/
9684:
9685: UPDATE cm_cmpt_mtl a
9686: SET a.legal_entity_id
9687: = (
9688: SELECT x.legal_entity_id
9689: FROM gl_plcy_mst x

Line 9694: UPDATE cm_cmpt_mtl a

9690: WHERE x.co_code = a.co_code
9691: )
9692: WHERE (a.legal_entity_id IS NULL AND a.co_code IS NOT NULL);
9693:
9694: UPDATE cm_cmpt_mtl a
9695: SET (
9696: a.master_organization_id,
9697: a.inventory_item_id
9698: )

Line 9715: UPDATE cm_cmpt_mtl a

9711: )
9712: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
9713: OR (a.master_organization_id IS NULL AND a.item_id IS NOT NULL);
9714:
9715: UPDATE cm_cmpt_mtl a
9716: SET a.delete_mark = 1
9717: WHERE a.ROWID NOT IN (
9718: SELECT MIN(x.ROWID)
9719: FROM cm_cmpt_mtl x

Line 9719: FROM cm_cmpt_mtl x

9715: UPDATE cm_cmpt_mtl a
9716: SET a.delete_mark = 1
9717: WHERE a.ROWID NOT IN (
9718: SELECT MIN(x.ROWID)
9719: FROM cm_cmpt_mtl x
9720: WHERE x.legal_entity_id = a.legal_Entity_id
9721: AND nvl(x.inventory_item_id, -1) = nvl(a.inventory_item_id, -1)
9722: AND nvl(x.cost_category_id, -1) = nvl(a.cost_category_id, -1)
9723: AND x.delete_mark <> 1

Line 9737: FROM cm_cmpt_mtl

9733: **********************************************/
9734:
9735: SELECT count(*)
9736: INTO x_failure_count
9737: FROM cm_cmpt_mtl
9738: WHERE (
9739: (inventory_item_id IS NULL AND item_id IS NOT NULL)
9740: OR (legal_entity_id IS NULL AND co_code IS NOT NULL)
9741: OR (master_organization_id IS NULL AND item_id IS NOT NULL)

Line 10573: * 05-Jul-2006 rseshadr bug 5374823 - removed cm_cmpt_mtl and *

10569: * Migrate_Items; *
10570: * *
10571: * HISTORY *
10572: * 26-May-2006 Created Anand Thiyagarajan *
10573: * 05-Jul-2006 rseshadr bug 5374823 - removed cm_cmpt_mtl and *
10574: * burden_percentages from cursor as these are now done inline *
10575: * *
10576: **********************************************************************/
10577: PROCEDURE Migrate_Items