DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on MTL_PARAMETERS

Line 1529: from mtl_parameters

1525: end if;
1526:
1527: Select organization_code
1528: into l_org_code
1529: from mtl_parameters
1530: where ORGANIZATION_ID = X_org_id;
1531:
1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

Line 1593: from MTL_PARAMETERS

1589: from fnd_id_flex_structures
1590: where id_flex_code = 'MTLL';
1591:
1592: Select project_reference_enabled into v_proj_ref_enabled
1593: from MTL_PARAMETERS
1594: where organization_id = X_org_id;
1595:
1596: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1597:

Line 1914: from MTL_PARAMETERS

1910: from fnd_id_flex_structures
1911: where id_flex_code = 'MTLL';
1912:
1913: Select project_reference_enabled into v_proj_ref_enabled
1914: from MTL_PARAMETERS
1915: where organization_id = X_org_id;
1916:
1917: -- bug 4662395 set the profile mfg_organization_id so
1918: -- the call to MTL_PROJECT_V will return data.

Line 2038: from mtl_system_items_kfv a , mtl_parameters b,

2034: Select concatenated_segments,organization_code,
2035: subinventory_name,locator_id,pull.organization_id
2036: into x_item_name,x_org_code,x_subinventory,l_locator_id,
2037: l_organization_id
2038: from mtl_system_items_kfv a , mtl_parameters b,
2039: mtl_kanban_pull_sequences pull
2040: where a.inventory_item_id = pull.inventory_item_id
2041: and a.organization_id = Pull.organization_id
2042: and b.organization_id = Pull.organization_id