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 613: TYPE uom_code IS TABLE OF msc_st_bom_components.uom_code%TYPE INDEX BY BINARY_INTEGER;

609: itm_mtq_routing_sequence_id routing_sequence_id ;
610: /* NAMIT_CR */
611: opr_stpdep_routing_sequence_id routing_sequence_id ;
612:
613: TYPE uom_code IS TABLE OF msc_st_bom_components.uom_code%TYPE INDEX BY BINARY_INTEGER;
614: bomc_uom_code uom_code ;
615: rtg_uom_code uom_code ;
616: or_uom_code uom_code ;
617: opr_uom_code uom_code ;

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

620: INDEX BY BINARY_INTEGER;
621: bom_assembly_item_id assembly_item_id ;
622: rtg_assembly_item_id assembly_item_id ;
623:
624: TYPE component_sequence_id IS TABLE OF msc_st_bom_components.component_sequence_id%TYPE
625: INDEX BY BINARY_INTEGER;
626: bomc_component_sequence_id component_sequence_id;
627: oc_component_sequence_id component_sequence_id;
628:

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

683:
684: bom_index INTEGER := 0 ; /* BOM Global counter */
685:
686: /* --------------------------- BOM Components declarations ------------------------ */
687: TYPE Inventory_item_id IS TABLE OF msc_st_bom_components.Inventory_item_id%TYPE
688: INDEX BY BINARY_INTEGER;
689: bomc_Inventory_item_id Inventory_item_id;
690:
691: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE

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

687: TYPE Inventory_item_id IS TABLE OF msc_st_bom_components.Inventory_item_id%TYPE
688: INDEX BY BINARY_INTEGER;
689: bomc_Inventory_item_id Inventory_item_id;
690:
691: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE
692: INDEX BY BINARY_INTEGER;
693: bomc_using_assembly_id using_assembly_id ;
694:
695: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE

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

691: TYPE using_assembly_id IS TABLE OF msc_st_bom_components.using_assembly_id%TYPE
692: INDEX BY BINARY_INTEGER;
693: bomc_using_assembly_id using_assembly_id ;
694:
695: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE
696: INDEX BY BINARY_INTEGER;
697: bomc_component_type component_type ;
698:
699: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE

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

695: TYPE component_type IS TABLE OF msc_st_bom_components.component_type%TYPE
696: INDEX BY BINARY_INTEGER;
697: bomc_component_type component_type ;
698:
699: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE
700: INDEX BY BINARY_INTEGER;
701: bomc_scaling_type bc_scaling_type;
702:
703: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE

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

699: TYPE bc_scaling_type IS TABLE OF msc_st_bom_components.scaling_type%TYPE
700: INDEX BY BINARY_INTEGER;
701: bomc_scaling_type bc_scaling_type;
702:
703: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE
704: INDEX BY BINARY_INTEGER;
705: bomc_usage_quantity usage_quantity ;
706:
707: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE

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

703: TYPE usage_quantity IS TABLE OF msc_st_bom_components.usage_quantity%TYPE
704: INDEX BY BINARY_INTEGER;
705: bomc_usage_quantity usage_quantity ;
706:
707: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE
708: INDEX BY BINARY_INTEGER;
709: bomc_opr_offset_percent operation_offset_percent ;
710:
711: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE

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

707: TYPE operation_offset_percent IS TABLE OF msc_st_bom_components.operation_offset_percent%TYPE
708: INDEX BY BINARY_INTEGER;
709: bomc_opr_offset_percent operation_offset_percent ;
710:
711: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE
712: INDEX BY BINARY_INTEGER;
713: bomc_optional_component optional_component ;
714:
715: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE

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

711: TYPE optional_component IS TABLE OF msc_st_bom_components.optional_component%TYPE
712: INDEX BY BINARY_INTEGER;
713: bomc_optional_component optional_component ;
714:
715: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE
716: INDEX BY BINARY_INTEGER;
717: bomc_wip_supply_type wip_supply_type ;
718:
719: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE

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

715: TYPE wip_supply_type IS TABLE OF msc_st_bom_components.wip_supply_type%TYPE
716: INDEX BY BINARY_INTEGER;
717: bomc_wip_supply_type wip_supply_type ;
718:
719: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE
720: INDEX BY BINARY_INTEGER;
721: bomc_scale_multiple scale_multiple;
722:
723: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE

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

719: TYPE scale_multiple IS TABLE OF msc_st_bom_components.scale_multiple%TYPE
720: INDEX BY BINARY_INTEGER;
721: bomc_scale_multiple scale_multiple;
722:
723: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE
724: INDEX BY BINARY_INTEGER;
725: bomc_scale_rounding_variance scale_rounding_variance ;
726:
727: TYPE rounding_direction IS TABLE OF msc_st_bom_components.rounding_direction%TYPE

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

723: TYPE scale_rounding_variance IS TABLE OF msc_st_bom_components.scale_rounding_variance%TYPE
724: INDEX BY BINARY_INTEGER;
725: bomc_scale_rounding_variance scale_rounding_variance ;
726:
727: TYPE rounding_direction IS TABLE OF msc_st_bom_components.rounding_direction%TYPE
728: INDEX BY BINARY_INTEGER;
729: bomc_rounding_direction rounding_direction ;
730:
731: /*B5176291 - Item substitution changes - start*/

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

728: INDEX BY BINARY_INTEGER;
729: bomc_rounding_direction rounding_direction ;
730:
731: /*B5176291 - Item substitution changes - start*/
732: TYPE b_disable_date IS TABLE OF msc_st_bom_components.disable_date%TYPE
733: INDEX BY BINARY_INTEGER;
734: bomc_disable_date b_disable_date ;
735: /*B5176291 - Item substitution changes - end*/
736:

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

1507: - B from 15/10/2006 to - (then remaining period)
1508: So the ae_flag is set for the substitute "B" to track that this substitute is to be replaced after
1509: 15/10/2006.
1510: And then for each ingredient/substitute their effective date and disbale date are passed on to
1511: msc_st_bom_components table with a component sequence id generated uniquely for the substitute items
1512: alone*/
1513:
1514:
1515: /*B5176291 - initialise the tables - start*/

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

4296: bomc_index := bomc_index + 1 ;
4297:
4298: /*B5176291 - item subtitution changes - start*/
4299: /*For sustitutes the formula line id will be null. component sequence id in
4300: msc_st_bom_components is a primary key. So the max value from gmd formula line sequence
4301: is fetched and global counter value is added to it.Then odd value is passed on to APS. */
4302: IF formula_detail_tab(loop_index).x_formulaline_id IS NOT NULL THEN
4303: bomc_component_sequence_id(bomc_index) := formula_detail_tab(loop_index).x_formulaline_id ;
4304: ELSE

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

4434: return_status := TRUE;
4435:
4436: EXCEPTION
4437: WHEN OTHERS THEN
4438: log_message('Error writing to msc_st_bom_components: '||sqlerrm);
4439: return_status := FALSE;
4440: END write_bom_components;
4441:
4442: /*

Line 6149: INSERT INTO msc_st_bom_components

6145: stmt_no := 903 ;
6146: i := 1 ;
6147: IF bomc_organization_id.FIRST > 0 THEN
6148: FORALL i IN bomc_organization_id.FIRST..bomc_organization_id.LAST
6149: INSERT INTO msc_st_bom_components
6150: (
6151: component_sequence_id,
6152: sr_instance_id,
6153: organization_id,