DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACTIVITY_PRODUCTS_S

Line 3278: FND_DSQL.add_text('SELECT ozf_activity_products_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

3274: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
3275: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');
3276: -- FND_DSQL.add_text('discount_line_id,apply_discount,include_volume,item,item_type) ');
3277: FND_DSQL.add_text('items_category,item,item_type) ');
3278: FND_DSQL.add_text('SELECT ozf_activity_products_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
3279: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
3280: FND_DSQL.add_bind(i.confidential_flag);
3281: FND_DSQL.add_text(',');
3282: FND_DSQL.add_bind(i.custom_setup_id);

Line 3494: FND_DSQL.add_text('SELECT ozf_activity_products_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

3490: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
3491: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');
3492: -- FND_DSQL.add_text('discount_line_id,apply_discount,include_volume,item,item_type) ');
3493: FND_DSQL.add_text('items_category,item,item_type) ');
3494: FND_DSQL.add_text('SELECT ozf_activity_products_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
3495: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
3496: FND_DSQL.add_bind(i.confidential_flag);
3497: FND_DSQL.add_text(',');
3498: FND_DSQL.add_bind(i.custom_setup_id);

Line 3987: SELECT ozf_activity_products_s.nextval,

3983: ACTUAL_UOM,
3984: LIST_PRICE,
3985: DISCOUNT,
3986: ITEMS_CATEGORY)
3987: SELECT ozf_activity_products_s.nextval,
3988: OBJECT_ID,
3989: OBJECT_TYPE,
3990: OBJECT_STATUS,
3991: OBJECT_CLASS,