DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on FND_ID_FLEX_SEGMENTS

Line 4195: lConfigSegName fnd_id_flex_segments.segment_name%type;

4191: lRcvOrg number;
4192:
4193: lReturnStatus varchar2(1);
4194:
4195: lConfigSegName fnd_id_flex_segments.segment_name%type;
4196: app_column fnd_id_flex_segments.segment_name%type;
4197: new_item_num mtl_system_items.segment1%Type ;
4198:
4199: lCreateRules varchar2(1);

Line 4196: app_column fnd_id_flex_segments.segment_name%type;

4192:
4193: lReturnStatus varchar2(1);
4194:
4195: lConfigSegName fnd_id_flex_segments.segment_name%type;
4196: app_column fnd_id_flex_segments.segment_name%type;
4197: new_item_num mtl_system_items.segment1%Type ;
4198:
4199: lCreateRules varchar2(1);
4200: lStatus number;

Line 4379: fnd_id_flex_segments fs,

4375:
4376: select nvl(fv.maximum_size,40), fs.application_column_name
4377: into lFndSize, app_column
4378: from -- bom_parameters p,
4379: fnd_id_flex_segments fs,
4380: fnd_flex_value_sets fv
4381: where --p.organization_id = lValidationOrg and
4382: fs.id_flex_code = 'MSTK'
4383: and fs.id_flex_num = 101