DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_HUB_QUERY_S

Line 106: select msc_hub_query_s.nextval into l_qid_vmi from dual;

102: l_stmt_id :=10;
103: ----------------------------------------------------
104:
105:
106: select msc_hub_query_s.nextval into l_qid_vmi from dual;
107:
108: insert into msc_hub_query(
109:
110: query_id,

Line 987: select msc_hub_query_s.nextval into l_qid_last_date from dual;

983:
984:
985:
986: l_stmt_id :=30;
987: select msc_hub_query_s.nextval into l_qid_last_date from dual;
988:
989: insert into msc_hub_query (
990: query_id,
991: last_update_date,

Line 1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;

1017:
1018:
1019:
1020: l_stmt_id :=40;
1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;
1022:
1023:
1024: insert into msc_hub_query (
1025: query_id,

Line 1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;

1043: commit;
1044:
1045:
1046: l_stmt_id :=45;
1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;
1048: insert into msc_hub_query (
1049: query_id,
1050: last_update_date,
1051: last_updated_by,

Line 1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;

1095:
1096:
1097:
1098: l_stmt_id :=50;
1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;
1100:
1101: insert into msc_hub_query (
1102: query_id,
1103: last_update_date,