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_COPY_BILL dependencies on BOM_STRUCTURES_B

Line 669: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;

665: ();
666: */
667: -- l_from_end_item_minor_rev_code VARCHAR2(30);
668: -- l_from_bom_item_minor_rev_code VARCHAR2 (30);
669: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
670: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
671: l_no_access_comp_cnt NUMBER;
672: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
673: l_current_item_rev mtl_item_revisions_b.revision%TYPE;

Line 670: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;

666: */
667: -- l_from_end_item_minor_rev_code VARCHAR2(30);
668: -- l_from_bom_item_minor_rev_code VARCHAR2 (30);
669: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
670: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
671: l_no_access_comp_cnt NUMBER;
672: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
673: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
674: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;

Line 705: FROM bom_structures_b bom,

701: SELECT 1
702: FROM DUAL
703: WHERE EXISTS (
704: SELECT NULL
705: FROM bom_structures_b bom,
706: bom_inventory_components bic
707: WHERE bom.organization_id <> to_org_id
708: AND bom.common_bill_sequence_id = to_sequence_id
709: AND bic.bill_sequence_id = to_sequence_id

Line 1062: FROM bom_structures_b

1058: SELECT common_bill_sequence_id,
1059: NVL (common_organization_id, organization_id)
1060: INTO x_from_sequence_id,
1061: x_from_org_id
1062: FROM bom_structures_b
1063: WHERE bill_sequence_id = x_from_sequence_id;
1064:
1065: SELECT structure_type_id, effectivity_control
1066: INTO l_str_type, l_from_eff_ctrl

Line 1067: FROM bom_structures_b

1063: WHERE bill_sequence_id = x_from_sequence_id;
1064:
1065: SELECT structure_type_id, effectivity_control
1066: INTO l_str_type, l_from_eff_ctrl
1067: FROM bom_structures_b
1068: WHERE bill_sequence_id = from_sequence_id;
1069:
1070: FOR c_comp_level IN C_DATA_LEVEL(l_data_level_name_comp) LOOP
1071: l_data_level_id_comp := c_comp_level.DATA_LEVEL_ID;

Line 6854: FROM bom_structures_b bsb

6850: BEGIN
6851: SELECT oav.organization_code, oav.organization_name,
6852: CASE
6853: WHEN EXISTS ( SELECT 1
6854: FROM bom_structures_b bsb
6855: WHERE bsb.organization_id = oav.organization_id
6856: AND bsb.assembly_item_id = p_item_id
6857: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6858: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id

Line 6862: FROM bom_structures_b bsb

6858: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id
6859: ) THEN
6860: 1 -- Structure already exists
6861: WHEN EXISTS ( SELECT 1
6862: FROM bom_structures_b bsb
6863: WHERE bsb.organization_id = oav.organization_id
6864: AND bsb.assembly_item_id = p_item_id
6865: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6866: AND bsb.bill_sequence_id <> bsb.common_bill_sequence_id

Line 6873: FROM bom_structures_b bsb

6869: ELSE
6870: 0 -- Structure does not exist
6871: END AS structure_exists,
6872: NVL((SELECT assembly_type
6873: FROM bom_structures_b bsb
6874: WHERE bsb.organization_id = x_org_list_tbl(l_index)
6875: AND bsb.assembly_item_id = p_item_id
6876: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6877: ),2) AS assembly_type,

Line 6986: bom_structures_b bsb,

6982: IS
6983: SELECT mp.organization_code
6984: FROM mtl_parameters mp,
6985: bom_copy_organization_list bcol,
6986: bom_structures_b bsb,
6987: bom_copy_structure_request bcsr
6988: WHERE bsb.assembly_item_id = cp_item_id
6989: AND bcsr.copy_request_id = cp_copy_request_id
6990: AND bsb.organization_id = bcol.organization_id

Line 7030: bom_structures_b bsb,

7026: IS
7027: SELECT mp.organization_code
7028: FROM mtl_parameters mp,
7029: bom_copy_organization_list bcol,
7030: bom_structures_b bsb,
7031: bom_copy_structure_request bcsr
7032: WHERE bsb.bill_sequence_id <> bsb.source_bill_sequence_id
7033: AND bsb.assembly_item_id = cp_item_id
7034: AND bcsr.copy_request_id = cp_copy_request_id

Line 7116: bom_structures_b bsb

7112: AND bcol.common_structure = 'N'
7113: AND NOT EXISTS (
7114: SELECT 1
7115: FROM bom_copy_structure_request bcsr,
7116: bom_structures_b bsb
7117: WHERE bsb.assembly_item_id = cp_item_id
7118: AND bcsr.copy_request_id = bcol.copy_request_id
7119: AND bsb.organization_id = bcol.organization_id
7120: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

Line 7159: bom_structures_b bsb

7155: AND bcol.common_structure = 'Y'
7156: AND NOT EXISTS (
7157: SELECT 1
7158: FROM bom_copy_structure_request bcsr,
7159: bom_structures_b bsb
7160: WHERE bcsr.copy_request_id = bcol.copy_request_id
7161: AND bsb.organization_id = bcol.organization_id
7162: AND bsb.assembly_item_id = cp_item_id
7163: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

Line 7309: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;

7305: l_count1 NUMBER;
7306: l_count2 NUMBER;
7307: l_count3 NUMBER;
7308: l_comp_ctr NUMBER;
7309: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7310: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7311: l_no_access_comp_cnt NUMBER;
7312: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7313: l_current_item_rev mtl_item_revisions_b.revision%TYPE;

Line 7310: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;

7306: l_count2 NUMBER;
7307: l_count3 NUMBER;
7308: l_comp_ctr NUMBER;
7309: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7310: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7311: l_no_access_comp_cnt NUMBER;
7312: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7313: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7314: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;

Line 7331: FROM bom_structures_b bom,

7327: SELECT 1
7328: FROM DUAL
7329: WHERE EXISTS (
7330: SELECT NULL
7331: FROM bom_structures_b bom,
7332: bom_inventory_components bic
7333: WHERE bom.organization_id <> to_org_id
7334: AND bom.common_bill_sequence_id = to_sequence_id
7335: AND bic.bill_sequence_id = to_sequence_id

Line 7516: FROM bom_structures_b

7512: SELECT common_bill_sequence_id,
7513: NVL (common_organization_id, organization_id)
7514: INTO x_from_sequence_id,
7515: x_from_org_id
7516: FROM bom_structures_b
7517: WHERE bill_sequence_id = x_from_sequence_id;
7518:
7519: SELECT structure_type_id, effectivity_control
7520: INTO l_str_type, l_from_eff_ctrl

Line 7521: FROM bom_structures_b

7517: WHERE bill_sequence_id = x_from_sequence_id;
7518:
7519: SELECT structure_type_id, effectivity_control
7520: INTO l_str_type, l_from_eff_ctrl
7521: FROM bom_structures_b
7522: WHERE bill_sequence_id = from_sequence_id;
7523:
7524: l_to_eff_ctrl := p_trgt_str_eff_ctrl;
7525:

Line 11832: bom_structures_b bsb

11828: SELECT bic.component_item_id component_item_id
11829: , bic.change_notice change_notice
11830: , bic.implementation_date implementation_date
11831: FROM bom_inventory_components bic,
11832: bom_structures_b bsb
11833: WHERE bic.bill_sequence_id = bsb.bill_sequence_id
11834: AND bsb.bill_sequence_id = p_bill_seq_id
11835: --Bug 10331803. Should not validate currently disabled components.
11836: AND (bic.disable_date is null OR bic.disable_date > NVL(BOM_EXPLODER_PUB.Get_Explosion_Date, SYSDATE))