eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_ROUTINGHEADER_PVT dependencies on DUAL

Line 323: From dual

319: l_msg_count NUMBER;
320: l_msg_data VARCHAR2(2000);
321: Cursor l_org_csr (P_OrgId number) is
322: Select 1 dummy
323: From dual
324: Where not exists (
325: Select null
326: From mtl_parameters
327: Where organization_id = P_OrgId);

Line 330: From dual

326: From mtl_parameters
327: Where organization_id = P_OrgId);
328: Cursor l_alternate_csr (P_OrgId number, P_Alt varchar2) is
329: Select 1 dummy
330: From dual
331: Where not exists (
332: Select null
333: From bom_alternate_designators
334: Where organization_id = P_OrgId

Line 338: From dual

334: Where organization_id = P_OrgId
335: And alternate_designator_code = P_Alt);
336: Cursor l_item_csr (P_Org number, P_Item number) is
337: Select 1 dummy
338: From dual
339: Where not exists (
340: select null
341: from mtl_system_items
342: where organization_id = P_Org

Line 347: From dual

343: and inventory_item_id = P_Item);
344: Cursor l_DupRtgs_csr (P_RtgSeqId number, P_AssyId number,
345: P_OrgId number, P_Alternate varchar2) is
346: Select 1 dummy
347: From dual
348: Where exists (
349: select null
350: from bom_operational_routings
351: where routing_sequence_id <> P_RtgSeqId

Line 359: From dual

355: = nvl(P_Alternate, 'Primary Alternate'));
356: Cursor l_CheckPrimary_csr (P_OrgId number, P_AssyId number,
357: P_RtgType number) is
358: Select 1 dummy
359: From dual
360: Where not exists (
361: select null
362: from bom_operational_routings
363: where organization_id = P_OrgId

Line 372: From dual

368: -- decode(P_RtgType, 2, routing_type, 1));
369: Cursor l_CheckAttributes_csr (
370: P_OrgId number, P_AssyId number, P_RtgType number) is
371: Select 1
372: From dual
373: Where not exists (
374: Select null
375: From mtl_system_items
376: Where organization_id = P_OrgId

Line 385: From dual

381: and eng_item_flag =
382: decode(P_RtgType, 2, eng_item_flag, 'N'));
383: Cursor l_CommonRtg_csr(P_RtgSeqId number) is
384: Select 1 dummy
385: From dual
386: Where not exists (
387: select null
388: from bom_operational_routings
389: where routing_sequence_id = P_RtgSeqId);

Line 403: From dual

399: P_item_id NUMBER,
400: P_org_id NUMBER,
401: P_alt_desg VARCHAR2) is
402: Select 1 dummy
403: From dual
404: Where not exists (
405: select null
406: from bom_operational_routings bor
407: where bor.routing_sequence_id = P_cmn_rtg_id

Line 460: from sys.dual

456: );
457: Cursor l_NonRestrictedLocators_csr (P_Location number, P_OrgId number,
458: P_SubInventory varchar2) is
459: select 1 dummy
460: from sys.dual
461: where not exists(
462: select null
463: from mtl_item_locations
464: where inventory_location_id = P_Location

Line 471: from dual

467: and nvl(disable_date, trunc(SYSDATE)+1) > trunc(SYSDATE));
468: Cursor l_RestrictedLocators_csr (P_Location number, P_OrgId number,
469: P_SubInventory varchar2, P_ItemId number) is
470: Select 1 dummy
471: from dual
472: where not exists(
473: select null
474: from mtl_item_locations loc,
475: mtl_secondary_locators item

Line 487: From dual

483: l_sub_loc_code number;
484: l_expense_to_asset_transfer number;
485: cursor l_line_csr(p_line_id number) is
486: Select 'x' dummy
487: From dual
488: Where not exists (
489: Select null
490: From wip_lines
491: Where line_id = p_line_id);

Line 495: From dual

491: Where line_id = p_line_id);
492: cursor l_MixedModelFlag_csr(p_item_id number, p_org_id number,
493: p_alternate varchar2, p_line_id number) is
494: Select 'x' dummy
495: From dual
496: Where exists (
497: Select null
498: From bom_operational_routings bor
499: Where bor.assembly_item_id = p_item_id

Line 509: From dual

505: And bor.mixed_model_map_flag = g_yes);
506: cursor l_DupPriority_csr(p_item_id number, p_org_id number,
507: p_alternate varchar2, p_priority number) is
508: Select 'x' dummy
509: From dual
510: Where exists (
511: Select null
512: From bom_operational_routings bor
513: Where bor.assembly_item_id = p_item_id

Line 522: From dual

518: And bor.priority = p_priority);
519: cursor l_ctp_csr(p_item_id number, p_org_id number,
520: p_alternate varchar2) is
521: Select 'x' dummy
522: From dual
523: Where exists (
524: Select null
525: From bom_operational_routings bor
526: Where bor.assembly_item_id = p_item_id

Line 998: From dual;

994: l_routing_rec ROUTING_REC_TYPE;
995: cursor l_NewRtg_csr is
996: Select
997: bom_operational_routings_s.nextval routing_sequence_id
998: From dual;
999: l_UserId number;
1000: l_LoginId number;
1001: l_RequestId number;
1002: l_ProgramId number;