DBA Data[Home] [Help]

APPS.INV_VENDORMERGE_GRP dependencies on MTL_KANBAN_CARDS

Line 55: ** MTL_KANBAN_CARDS via: MTL_KANBAN_CARDS_FK8

51: ** Following tables have reference to vendor and are candidates for
52: ** vendor merge:
53: **
54: ** MTL_INTERCOMPANY_PARAMETERS via: MTL_INTERCO_PARAMETERS_FK03
55: ** MTL_KANBAN_CARDS via: MTL_KANBAN_CARDS_FK8
56: ** MTL_KANBAN_CARD_ACTIVITY via: MTL_KANBAN_CARD_ACTIVITY_FK9
57: ** MTL_KANBAN_PULL_SEQUENCES via: MTL_KANBAN_PULL_SEQUNECES_FK5
58: ** MTL_SERIAL_NUMBERS via: MTL_SERIAL_NUMBERS_FK11
59: */

Line 65: update MTL_KANBAN_CARDS

61: update MTL_INTERCOMPANY_PARAMETERS
62: set vendor_id = p_vendor_id
63: where vendor_id = p_dup_vendor_id;
64:
65: update MTL_KANBAN_CARDS
66: set supplier_id = p_vendor_id
67: where supplier_id = p_dup_vendor_id;
68:
69: update MTL_KANBAN_CARD_ACTIVITY

Line 86: ** MTL_KANBAN_CARDS via: MTL_KANBAN_CARDS_FK9

82: ** Following tables have reference to vendor site and are candidates for
83: ** vendor merge:
84: **
85: ** MTL_INTERCOMPANY_PARAMETERS via: MTL_INTERCO_PARAMETERS_FK04
86: ** MTL_KANBAN_CARDS via: MTL_KANBAN_CARDS_FK9
87: ** MTL_KANBAN_CARD_ACTIVITY via: MTL_KANBAN_CARD_ACTIVITY_FK10
88: ** MTL_KANBAN_PULL_SEQUENCES via: MTL_KANBAN_PULL_SEQUENCES_FK6
89: */
90:

Line 95: update MTL_KANBAN_CARDS

91: update MTL_INTERCOMPANY_PARAMETERS
92: set vendor_site_id = p_vendor_site_id
93: where vendor_site_id = p_dup_vendor_site_id;
94:
95: update MTL_KANBAN_CARDS
96: set supplier_site_id = p_vendor_site_id
97: where supplier_site_id = p_dup_vendor_site_id;
98:
99: update MTL_KANBAN_CARD_ACTIVITY