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 701: FROM bom_structures_b bom,

697: SELECT 1
698: FROM DUAL
699: WHERE EXISTS (
700: SELECT NULL
701: FROM bom_structures_b bom,
702: bom_inventory_components bic
703: WHERE bom.organization_id <> to_org_id
704: AND bom.common_bill_sequence_id = to_sequence_id
705: AND bic.bill_sequence_id = to_sequence_id

Line 1041: FROM bom_structures_b

1037: SELECT common_bill_sequence_id,
1038: NVL (common_organization_id, organization_id)
1039: INTO x_from_sequence_id,
1040: x_from_org_id
1041: FROM bom_structures_b
1042: WHERE bill_sequence_id = x_from_sequence_id;
1043:
1044: SELECT structure_type_id, effectivity_control
1045: INTO l_str_type, l_from_eff_ctrl

Line 1046: FROM bom_structures_b

1042: WHERE bill_sequence_id = x_from_sequence_id;
1043:
1044: SELECT structure_type_id, effectivity_control
1045: INTO l_str_type, l_from_eff_ctrl
1046: FROM bom_structures_b
1047: WHERE bill_sequence_id = from_sequence_id;
1048:
1049: l_to_eff_ctrl := p_trgt_str_eff_ctrl;
1050:

Line 6758: FROM bom_structures_b bsb

6754: BEGIN
6755: SELECT oav.organization_code, oav.organization_name,
6756: CASE
6757: WHEN EXISTS ( SELECT 1
6758: FROM bom_structures_b bsb
6759: WHERE bsb.organization_id = oav.organization_id
6760: AND bsb.assembly_item_id = p_item_id
6761: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6762: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id

Line 6766: FROM bom_structures_b bsb

6762: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id
6763: ) THEN
6764: 1 -- Structure already exists
6765: WHEN EXISTS ( SELECT 1
6766: FROM bom_structures_b bsb
6767: WHERE bsb.organization_id = oav.organization_id
6768: AND bsb.assembly_item_id = p_item_id
6769: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6770: AND bsb.bill_sequence_id <> bsb.common_bill_sequence_id

Line 6777: FROM bom_structures_b bsb

6773: ELSE
6774: 0 -- Structure does not exist
6775: END AS structure_exists,
6776: NVL((SELECT assembly_type
6777: FROM bom_structures_b bsb
6778: WHERE bsb.organization_id = x_org_list_tbl(l_index)
6779: AND bsb.assembly_item_id = p_item_id
6780: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6781: ),2) AS assembly_type,

Line 6890: bom_structures_b bsb,

6886: IS
6887: SELECT mp.organization_code
6888: FROM mtl_parameters mp,
6889: bom_copy_organization_list bcol,
6890: bom_structures_b bsb,
6891: bom_copy_structure_request bcsr
6892: WHERE bsb.assembly_item_id = cp_item_id
6893: AND bcsr.copy_request_id = cp_copy_request_id
6894: AND bsb.organization_id = bcol.organization_id

Line 6934: bom_structures_b bsb,

6930: IS
6931: SELECT mp.organization_code
6932: FROM mtl_parameters mp,
6933: bom_copy_organization_list bcol,
6934: bom_structures_b bsb,
6935: bom_copy_structure_request bcsr
6936: WHERE bsb.bill_sequence_id <> bsb.source_bill_sequence_id
6937: AND bsb.assembly_item_id = cp_item_id
6938: AND bcsr.copy_request_id = cp_copy_request_id

Line 7020: bom_structures_b bsb

7016: AND bcol.common_structure = 'N'
7017: AND NOT EXISTS (
7018: SELECT 1
7019: FROM bom_copy_structure_request bcsr,
7020: bom_structures_b bsb
7021: WHERE bsb.assembly_item_id = cp_item_id
7022: AND bcsr.copy_request_id = bcol.copy_request_id
7023: AND bsb.organization_id = bcol.organization_id
7024: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

Line 7063: bom_structures_b bsb

7059: AND bcol.common_structure = 'Y'
7060: AND NOT EXISTS (
7061: SELECT 1
7062: FROM bom_copy_structure_request bcsr,
7063: bom_structures_b bsb
7064: WHERE bcsr.copy_request_id = bcol.copy_request_id
7065: AND bsb.organization_id = bcol.organization_id
7066: AND bsb.assembly_item_id = cp_item_id
7067: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

Line 7213: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;

7209: l_count1 NUMBER;
7210: l_count2 NUMBER;
7211: l_count3 NUMBER;
7212: l_comp_ctr NUMBER;
7213: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7214: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7215: l_no_access_comp_cnt NUMBER;
7216: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7217: l_current_item_rev mtl_item_revisions_b.revision%TYPE;

Line 7214: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;

7210: l_count2 NUMBER;
7211: l_count3 NUMBER;
7212: l_comp_ctr NUMBER;
7213: l_from_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7214: l_to_eff_ctrl bom_structures_b.effectivity_control%TYPE;
7215: l_no_access_comp_cnt NUMBER;
7216: l_fixed_rev mtl_item_revisions_b.revision%TYPE;
7217: l_current_item_rev mtl_item_revisions_b.revision%TYPE;
7218: l_current_item_rev_id mtl_item_revisions_b.revision_id%TYPE;

Line 7231: FROM bom_structures_b bom,

7227: SELECT 1
7228: FROM DUAL
7229: WHERE EXISTS (
7230: SELECT NULL
7231: FROM bom_structures_b bom,
7232: bom_inventory_components bic
7233: WHERE bom.organization_id <> to_org_id
7234: AND bom.common_bill_sequence_id = to_sequence_id
7235: AND bic.bill_sequence_id = to_sequence_id

Line 7401: FROM bom_structures_b

7397: SELECT common_bill_sequence_id,
7398: NVL (common_organization_id, organization_id)
7399: INTO x_from_sequence_id,
7400: x_from_org_id
7401: FROM bom_structures_b
7402: WHERE bill_sequence_id = x_from_sequence_id;
7403:
7404: SELECT structure_type_id, effectivity_control
7405: INTO l_str_type, l_from_eff_ctrl

Line 7406: FROM bom_structures_b

7402: WHERE bill_sequence_id = x_from_sequence_id;
7403:
7404: SELECT structure_type_id, effectivity_control
7405: INTO l_str_type, l_from_eff_ctrl
7406: FROM bom_structures_b
7407: WHERE bill_sequence_id = from_sequence_id;
7408:
7409: l_to_eff_ctrl := p_trgt_str_eff_ctrl;
7410: