APPS.GMF_MIGRATION dependencies on CM_CMPT_MTL

Line 9915: * only master_organization_id in table cm_cmpt_mtl along with *

9911: * 27-Apr-2005 Created Anand Thiyagarajan *
9912: * 05-Jul-2006 rseshadr bug 5374823 - call item mig inline for *
9913: * the current table *
9914: * 06-Mar-2012 phiriyan Bug 13612793- As the script is updating *
9915: * only master_organization_id in table cm_cmpt_mtl along with *
9916: * inventory_item_id, Modified cur_get_gmf_items to restrict *
9917: * data to master_organization_id. So as to reduce the calls *
9918: * to item migration API. *
9919: **********************************************************************/

Line 9951: FROM cm_cmpt_mtl a,

9947: z.master_organization_id as organization_id/*B13612793 */
9948: FROM (
9949: SELECT a.item_id,
9950: decode(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
9951: FROM cm_cmpt_mtl a,
9952: sy_orgn_mst b,
9953: ic_whse_mst c
9954: WHERE a.item_id IS NOT NULL
9955: AND a.co_code = b.co_code

Line 9966: G_Table_name := 'CM_CMPT_MTL';

9962:
9963: BEGIN
9964:
9965: G_Migration_run_id := P_migration_run_id;
9966: G_Table_name := 'CM_CMPT_MTL';
9967: G_Context := 'Material Cost Components Migration';
9968: X_failure_count := 0;
9969:
9970: /********************************

Line 10012: UPDATE cm_cmpt_mtl a

10008: /*****************************************
10009: * Update rows For Legal Entity and Item *
10010: *****************************************/
10011:
10012: UPDATE cm_cmpt_mtl a
10013: SET a.legal_entity_id
10014: = (
10015: SELECT x.legal_entity_id
10016: FROM gl_plcy_mst x

Line 10021: UPDATE cm_cmpt_mtl a

10017: WHERE x.co_code = a.co_code
10018: )
10019: WHERE (a.legal_entity_id IS NULL AND a.co_code IS NOT NULL);
10020:
10021: UPDATE cm_cmpt_mtl a
10022: SET (
10023: a.master_organization_id,
10024: a.inventory_item_id
10025: )

Line 10042: UPDATE cm_cmpt_mtl a

10038: )
10039: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
10040: OR (a.master_organization_id IS NULL AND a.item_id IS NOT NULL);
10041:
10042: UPDATE cm_cmpt_mtl a
10043: SET a.delete_mark = 1
10044: WHERE a.ROWID NOT IN (
10045: SELECT MIN(x.ROWID)
10046: FROM cm_cmpt_mtl x

Line 10046: FROM cm_cmpt_mtl x

10042: UPDATE cm_cmpt_mtl a
10043: SET a.delete_mark = 1
10044: WHERE a.ROWID NOT IN (
10045: SELECT MIN(x.ROWID)
10046: FROM cm_cmpt_mtl x
10047: WHERE x.legal_entity_id = a.legal_Entity_id
10048: AND nvl(x.inventory_item_id, -1) = nvl(a.inventory_item_id, -1)
10049: AND nvl(x.cost_category_id, -1) = nvl(a.cost_category_id, -1)
10050: AND x.delete_mark <> 1

Line 10064: FROM cm_cmpt_mtl

10060: **********************************************/
10061:
10062: SELECT count(*)
10063: INTO x_failure_count
10064: FROM cm_cmpt_mtl
10065: WHERE (
10066: (inventory_item_id IS NULL AND item_id IS NOT NULL)
10067: OR (legal_entity_id IS NULL AND co_code IS NOT NULL)
10068: OR (master_organization_id IS NULL AND item_id IS NOT NULL)

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

10898: * Migrate_Items; *
10899: * *
10900: * HISTORY *
10901: * 26-May-2006 Created Anand Thiyagarajan *
10902: * 05-Jul-2006 rseshadr bug 5374823 - removed cm_cmpt_mtl and *
10903: * burden_percentages from cursor as these are now done inline *
10904: * 07-Mar-2012 rpatangy bug 13801023 - added condition *
10905: * *
10906: **********************************************************************/