APPS.BOM_ROUTINGREVISION_PVT dependencies on DUAL

Line 122: From dual

118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(2000);
120: cursor l_org_csr(P_OrgId number) is
121: Select 'x' dummy
122: From dual
123: Where not exists(
124: Select null
125: From mtl_parameters
126: where organization_id = P_OrgId);

Line 129: From dual

125: From mtl_parameters
126: where organization_id = P_OrgId);
127: cursor l_item_csr(P_ItemId number, P_OrgId number) is
128: Select 'x' dummy
129: From dual
130: Where not exists(
131: Select null
132: from mtl_system_items
133: where organization_id = P_OrgId

Line 137: From dual

133: where organization_id = P_OrgId
134: and inventory_item_id = P_ItemId);
135: cursor l_routing_csr(P_ItemId number, P_OrgId number) is
136: Select 'x' dummy
137: From dual
138: Where not exists(
139: Select null
140: from bom_operational_routings
141: where organization_id = P_OrgId

Line 146: from dual

142: and assembly_item_id = P_ItemId);
143: cursor l_OtherRevs_csr(P_ItemId number, P_OrgId number,
144: P_Revision varchar2, P_EffDate date) is
145: Select 'x' dummy
146: from dual
147: Where exists(
148: Select null
149: from mtl_rtg_item_revisions
150: where inventory_item_id = P_ItemId