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_BOM_COMPONENTS

Line 640: TYPE uom_code IS TABLE OF msc_st_bom_components.uom_code%TYPE INDEX BY BINARY_INTEGER;

636: itm_mtq_routing_sequence_id routing_sequence_id ;
637: /* NAMIT_CR */
638: opr_stpdep_routing_sequence_id routing_sequence_id ;
639:
640: TYPE uom_code IS TABLE OF msc_st_bom_components.uom_code%TYPE INDEX BY BINARY_INTEGER;
641: bomc_uom_code uom_code ;
642: rtg_uom_code uom_code ;
643: or_uom_code uom_code ;
644: opr_uom_code uom_code ;

Line 651: TYPE component_sequence_id IS TABLE OF msc_st_bom_components.component_sequence_id%TYPE

647: INDEX BY BINARY_INTEGER;
648: bom_assembly_item_id assembly_item_id ;
649: rtg_assembly_item_id assembly_item_id ;
650:
651: TYPE component_sequence_id IS TABLE OF msc_st_bom_components.component_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:

Line 719: TYPE Inventory_item_id IS TABLE OF msc_st_bom_components.Inventory_item_id%TYPE

715:
716: bom_index INTEGER := 0 ; /* BOM Global counter */
717:
718: /* --------------------------- BOM Components declarations ------------------------ */
719: TYPE Inventory_item_id IS TABLE OF msc_st_bom_components.Inventory_item_id%TYPE
720: INDEX BY BINARY_INTEGER;
721: bomc_Inventory_item_id Inventory_item_id;
722:
723: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE

Line 723: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE

719: TYPE Inventory_item_id IS TABLE OF msc_st_bom_components.Inventory_item_id%TYPE
720: INDEX BY BINARY_INTEGER;
721: bomc_Inventory_item_id Inventory_item_id;
722:
723: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE
724: INDEX BY BINARY_INTEGER;
725: bomc_using_assembly_id using_assembly_id ;
726:
727: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE

Line 727: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE

723: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE
724: INDEX BY BINARY_INTEGER;
725: bomc_using_assembly_id using_assembly_id ;
726:
727: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE
728: INDEX BY BINARY_INTEGER;
729: bomc_component_type component_type ;
730:
731: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE

Line 731: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE

727: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE
728: INDEX BY BINARY_INTEGER;
729: bomc_component_type component_type ;
730:
731: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE
732: INDEX BY BINARY_INTEGER;
733: bomc_scaling_type bc_scaling_type;
734:
735: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE

Line 735: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE

731: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE
732: INDEX BY BINARY_INTEGER;
733: bomc_scaling_type bc_scaling_type;
734:
735: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE
736: INDEX BY BINARY_INTEGER;
737: bomc_usage_quantity usage_quantity ;
738:
739: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE

Line 739: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE

735: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE
736: INDEX BY BINARY_INTEGER;
737: bomc_usage_quantity usage_quantity ;
738:
739: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE
740: INDEX BY BINARY_INTEGER;
741: bomc_opr_offset_percent operation_offset_percent ;
742:
743: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE

Line 743: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE

739: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE
740: INDEX BY BINARY_INTEGER;
741: bomc_opr_offset_percent operation_offset_percent ;
742:
743: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE
744: INDEX BY BINARY_INTEGER;
745: bomc_optional_component optional_component ;
746:
747: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE

Line 747: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE

743: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE
744: INDEX BY BINARY_INTEGER;
745: bomc_optional_component optional_component ;
746:
747: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE
748: INDEX BY BINARY_INTEGER;
749: bomc_wip_supply_type wip_supply_type ;
750:
751: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE

Line 751: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE

747: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE
748: INDEX BY BINARY_INTEGER;
749: bomc_wip_supply_type wip_supply_type ;
750:
751: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE
752: INDEX BY BINARY_INTEGER;
753: bomc_scale_multiple scale_multiple;
754:
755: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE

Line 755: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE

751: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE
752: INDEX BY BINARY_INTEGER;
753: bomc_scale_multiple scale_multiple;
754:
755: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE
756: INDEX BY BINARY_INTEGER;
757: bomc_scale_rounding_variance scale_rounding_variance ;
758:
759: TYPE rounding_direction IS TABLE OF msc_st_bom_components.rounding_direction%TYPE

Line 759: TYPE rounding_direction IS TABLE OF msc_st_bom_components.rounding_direction%TYPE

755: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE
756: INDEX BY BINARY_INTEGER;
757: bomc_scale_rounding_variance scale_rounding_variance ;
758:
759: TYPE rounding_direction IS TABLE OF msc_st_bom_components.rounding_direction%TYPE
760: INDEX BY BINARY_INTEGER;
761: bomc_rounding_direction rounding_direction ;
762:
763: /*B5176291 - Item substitution changes - start*/

Line 764: TYPE b_disable_date IS TABLE OF msc_st_bom_components.disable_date%TYPE

760: INDEX BY BINARY_INTEGER;
761: bomc_rounding_direction rounding_direction ;
762:
763: /*B5176291 - Item substitution changes - start*/
764: TYPE b_disable_date IS TABLE OF msc_st_bom_components.disable_date%TYPE
765: INDEX BY BINARY_INTEGER;
766: bomc_disable_date b_disable_date ;
767: /*B5176291 - Item substitution changes - end*/
768:

Line 1580: msc_st_bom_components table with a component sequence id generated uniquely for the substitute items

1576: - B from 15/10/2006 to - (then remaining period)
1577: So the ae_flag is set for the substitute "B" to track that this substitute is to be replaced after
1578: 15/10/2006.
1579: And then for each ingredient/substitute their effective date and disbale date are passed on to
1580: msc_st_bom_components table with a component sequence id generated uniquely for the substitute items
1581: alone*/
1582:
1583:
1584: /*B5176291 - initialise the tables - start*/

Line 4751: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence

4747: bomc_index := bomc_index + 1 ;
4748:
4749: /*B5176291 - item subtitution changes - start*/
4750: /*For sustitutes the formula line id will be null. component sequence id in
4751: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence
4752: is fetched and global counter value is added to it.Then odd value is passed on to APS. */
4753: IF formula_detail_tab(loop_index).x_formulaline_id IS NOT NULL THEN
4754: bomc_component_sequence_id(bomc_index) := formula_detail_tab(loop_index).x_formulaline_id ;
4755: ELSE

Line 4894: log_message('Error writing to msc_st_bom_components: '||sqlerrm);

4890: return_status := TRUE;
4891:
4892: EXCEPTION
4893: WHEN OTHERS THEN
4894: log_message('Error writing to msc_st_bom_components: '||sqlerrm);
4895: return_status := FALSE;
4896: END write_bom_components;
4897:
4898: /*

Line 6693: INSERT INTO msc_st_bom_components

6689: stmt_no := 903 ;
6690: i := 1 ;
6691: IF bomc_organization_id.FIRST > 0 THEN
6692: FORALL i IN bomc_organization_id.FIRST..bomc_organization_id.LAST
6693: INSERT INTO msc_st_bom_components
6694: (
6695: component_sequence_id,
6696: sr_instance_id,
6697: organization_id,