DBA Data[Home] [Help]

APPS.MSC_DRP_HORI_PLAN dependencies on MSC_DRP_HORI_PLANS

Line 1077: INSERT INTO msc_drp_hori_plans(

1073: row_detail(bkt + (a-1)*(g_num_of_buckets+1)).volume;
1074: END LOOP;
1075:
1076: FORALL bkt IN 1..g_num_of_buckets
1077: INSERT INTO msc_drp_hori_plans(
1078: query_id,
1079: organization_id,
1080: sr_instance_id,
1081: inventory_item_id,

Line 1136: INSERT INTO msc_drp_hori_plans(

1132: sub_row_detail(bkt +(a-1)*(g_num_of_buckets)).volume;
1133: END LOOP;
1134:
1135: FORALL bkt IN 1..g_num_of_buckets
1136: INSERT INTO msc_drp_hori_plans(
1137: query_id,
1138: organization_id,
1139: sr_instance_id,
1140: inventory_item_id,

Line 1174: INSERT INTO msc_drp_hori_plans(

1170: g_error_stmt := 'Debug - flush_item_plan - 80';
1171:
1172: -- insert enterprise data
1173: FORALL a in 1 .. nvl(etp_bkt_quantity.last, 0)
1174: INSERT INTO msc_drp_hori_plans(
1175: query_id,
1176: organization_id,
1177: sr_instance_id,
1178: inventory_item_id,