DBA Data[Home] [Help]

APPS.INVPVALI dependencies on MTL_PARAMETERS

Line 64: Also removed mtl_parameters as it is not required here

60: /*
61: Bug 1725851 : Removed + 0 on Set Process Id as it was causing
62: Performance issues. Removing this uses Index
63: mtl_item_revs_interface_N3 index instead of FULL Table Scan.
64: Also removed mtl_parameters as it is not required here
65: */
66: --User can now populate revision_id in the interface table.
67: CURSOR dd is
68: select transaction_id,

Line 222: from mtl_parameters

218: --2885843: default revision error propagated to imported item
219: CURSOR c_get_default_rev(cp_org_id NUMBER)
220: IS
221: select starting_revision
222: from mtl_parameters
223: where organization_id = cp_org_id;
224:
225: CURSOR is_gdsn_batch(cp_xset_id NUMBER) IS
226: SELECT 1 FROM ego_import_option_sets