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.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_OPERATION_RESOURCES

Line 656: TYPE operation_sequence_id IS TABLE OF msc_st_operation_resources.operation_sequence_id%TYPE

652: INDEX BY BINARY_INTEGER;
653: bomc_component_sequence_id component_sequence_id;
654: oc_component_sequence_id component_sequence_id;
655:
656: TYPE operation_sequence_id IS TABLE OF msc_st_operation_resources.operation_sequence_id%TYPE
657: INDEX BY BINARY_INTEGER;
658: or_operation_sequence_id operation_sequence_id ;
659: opr_operation_sequence_id operation_sequence_id ;
660: rs_operation_sequence_id operation_sequence_id ;

Line 668: TYPE resource_seq_num IS TABLE OF msc_st_operation_resources.resource_seq_num%TYPE

664: TYPE operation_leadtime_per IS TABLE OF msc_st_routing_operations.operation_lead_time_percent%TYPE
665: INDEX BY BINARY_INTEGER;
666: opr_lead_time_percent operation_leadtime_per ;
667:
668: TYPE resource_seq_num IS TABLE OF msc_st_operation_resources.resource_seq_num%TYPE
669: INDEX BY BINARY_INTEGER;
670: or_resource_seq_num resource_seq_num ;
671: rs_resource_seq_num resource_seq_num ;
672: /* SGIDUGU - Seq Dep */

Line 824: TYPE resource_id IS TABLE OF msc_st_operation_resources.resource_id%TYPE

820:
821: rtg_index INTEGER := 0 ; /* Routing Global counter */
822:
823: /* -------------------------- Routng operations declarations ------------------------ */
824: TYPE resource_id IS TABLE OF msc_st_operation_resources.resource_id%TYPE
825: INDEX BY BINARY_INTEGER;
826: or_resource_id resource_id ;
827: gt_resource_id resource_id ;
828:

Line 829: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE

825: INDEX BY BINARY_INTEGER;
826: or_resource_id resource_id ;
827: gt_resource_id resource_id ;
828:
829: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE
830: INDEX BY BINARY_INTEGER;
831: or_alternate_number alternate_number ;
832:
833: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE

Line 833: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE

829: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE
830: INDEX BY BINARY_INTEGER;
831: or_alternate_number alternate_number ;
832:
833: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE
834: INDEX BY BINARY_INTEGER;
835: or_principal_flag principal_flag ;
836:
837: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE

Line 837: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE

833: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE
834: INDEX BY BINARY_INTEGER;
835: or_principal_flag principal_flag ;
836:
837: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE
838: INDEX BY BINARY_INTEGER;
839: or_basis_type basis_type ;
840:
841: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE

Line 841: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE

837: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE
838: INDEX BY BINARY_INTEGER;
839: or_basis_type basis_type ;
840:
841: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE
842: INDEX BY BINARY_INTEGER;
843: or_resource_usage resource_usage ;
844:
845: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE

Line 845: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE

841: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE
842: INDEX BY BINARY_INTEGER;
843: or_resource_usage resource_usage ;
844:
845: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE
846: INDEX BY BINARY_INTEGER;
847: or_max_resource_units max_resource_units ;
848:
849: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE

Line 849: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE

845: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE
846: INDEX BY BINARY_INTEGER;
847: or_max_resource_units max_resource_units ;
848:
849: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE
850: INDEX BY BINARY_INTEGER;
851: or_resource_units resource_units ;
852:
853: TYPE or_orig_rs_seq_num_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 5493: into msc_st_operation_resources table. Also keep track of number of

5489:
5490: /*
5491: Now the check if the above resource inserted is a Primary. If it is
5492: Primary then find its Alternates if existing, and then insert its rows
5493: into msc_st_operation_resources table. Also keep track of number of
5494: times alternates are inserted. 1319610
5495: */
5496:
5497: statement_no := 120 ;

Line 6850: INSERT INTO msc_st_operation_resources (

6846:
6847: --
6848: IF or_operation_sequence_id.FIRST > 0 THEN
6849: FORALL i IN or_operation_sequence_id.FIRST..or_operation_sequence_id.LAST
6850: INSERT INTO msc_st_operation_resources (
6851: operation_sequence_id,
6852: resource_seq_num,
6853: resource_id,
6854: alternate_number,

Line 7589: ||' (select /+ noparallel(msc_st_operation_resources) / unique mt.RESOURCE_ID, mt.ORGANIZATION_ID,'

7585: ||' b.uom_code, '
7586: ||' b.sr_instance_id, '
7587: ||' b.deleted_flag '
7588: ||' FROM gmp_sequence_dependencies'||at_apps_link||' a, '
7589: ||' (select /*+ noparallel(msc_st_operation_resources) */ unique mt.RESOURCE_ID, mt.ORGANIZATION_ID,'
7590: ||' mt.SETUP_ID , mt.deleted_flag, mt.sr_instance_id, mt.UOM_CODE '
7591: ||' FROM mtl_parameters'||at_apps_link|| ' mp, '
7592: ||' MSC_ST_OPERATION_RESOURCES mt '
7593: ||' WHERE mp.organization_id = mt.organization_id AND '

Line 7592: ||' MSC_ST_OPERATION_RESOURCES mt '

7588: ||' FROM gmp_sequence_dependencies'||at_apps_link||' a, '
7589: ||' (select /*+ noparallel(msc_st_operation_resources) */ unique mt.RESOURCE_ID, mt.ORGANIZATION_ID,'
7590: ||' mt.SETUP_ID , mt.deleted_flag, mt.sr_instance_id, mt.UOM_CODE '
7591: ||' FROM mtl_parameters'||at_apps_link|| ' mp, '
7592: ||' MSC_ST_OPERATION_RESOURCES mt '
7593: ||' WHERE mp.organization_id = mt.organization_id AND '
7594: ||' mt.sr_instance_id = :instance1 AND '
7595: ||' mt.setup_id is not null AND '
7596: ||' mp.process_enabled_flag = '|| ''''||'Y'||'''' ||' ) b '

Line 7606: ||' (select /+ noparallel(msc_st_operation_resources) / '

7602: END IF;
7603:
7604: Fact_tran := Fact_tran
7605: ||' ) a , '
7606: ||' (select /*+ noparallel(msc_st_operation_resources) */ '
7607: ||' unique mt.RESOURCE_ID, mt.ORGANIZATION_ID,'
7608: ||' mt.SETUP_ID , mt.deleted_flag, mt.sr_instance_id, mt.UOM_CODE '
7609: ||' FROM MSC_ST_OPERATION_RESOURCES mt '
7610: ||' WHERE mt.sr_instance_id = :instance2 ' ;

Line 7609: ||' FROM MSC_ST_OPERATION_RESOURCES mt '

7605: ||' ) a , '
7606: ||' (select /*+ noparallel(msc_st_operation_resources) */ '
7607: ||' unique mt.RESOURCE_ID, mt.ORGANIZATION_ID,'
7608: ||' mt.SETUP_ID , mt.deleted_flag, mt.sr_instance_id, mt.UOM_CODE '
7609: ||' FROM MSC_ST_OPERATION_RESOURCES mt '
7610: ||' WHERE mt.sr_instance_id = :instance2 ' ;
7611:
7612: IF l_in_str_org IS NOT NULL THEN
7613: Fact_tran := Fact_tran