DBA Data[Home] [Help]

APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on STANDARD

Line 64: standard_rate_flag,

60: resource_code,
61: usage_rate_or_amount,
62: basis_type,
63: autocharge_type,
64: standard_rate_flag,
65: transaction_quantity,
66: transaction_uom,
67: primary_quantity,
68: primary_uom,

Line 123: BOR.STANDARD_RATE_FLAG,

119: BR.RESOURCE_CODE,
120: BOR.USAGE_RATE_OR_AMOUNT,
121: BOR.BASIS_TYPE,
122: BOR.AUTOCHARGE_TYPE,
123: BOR.STANDARD_RATE_FLAG,
124: BOR.USAGE_RATE_OR_AMOUNT * DECODE (BOR.BASIS_TYPE,
125: 1, -1*MMTT.PRIMARY_QUANTITY,
126: 2, DECODE(wfs.QUANTITY_COMPLETED,
127: 0, 1,

Line 262: standard_rate_flag,

258: resource_code,
259: usage_rate_or_amount,
260: basis_type,
261: autocharge_type,
262: standard_rate_flag,
263: transaction_quantity,
264: transaction_uom,
265: primary_quantity,
266: primary_uom,

Line 427: standard_rate_flag,

423: resource_code,
424: usage_rate_or_amount,
425: basis_type,
426: autocharge_type,
427: standard_rate_flag,
428: transaction_quantity,
429: transaction_uom,
430: primary_quantity,
431: primary_uom,

Line 598: BOR.standard_rate_flag ,

594:
595: CURSOR phan_resc_cursor(p_rtg_revision_date date) IS
596: SELECT BOR.resource_id ,
597: BOR.activity_id ,
598: BOR.standard_rate_flag ,
599: BOR.assigned_units ,
600: BOR.usage_rate_or_amount ,
601: BOR.basis_type ,
602: BOR.autocharge_type ,

Line 750: standard_rate_flag,

746: activity_id,
747: scheduled_flag,
748: assigned_units,
749: autocharge_type,
750: standard_rate_flag,
751: applied_resource_units,
752: applied_resource_value,
753: start_date,
754: completion_date,

Line 787: cur_resc.standard_rate_flag,

783: cur_resc.activity_id,
784: 2, /* non-scheduled */
785: cur_resc.assigned_units,
786: cur_resc.autocharge_type,
787: cur_resc.standard_rate_flag,
788: x_applied_resource_units,
789: x_applied_resource_value,
790: x_start_date,
791: x_completion_date,