DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_STRUCTURES_B

Line 1518: FROM bom_structures_b

1514: RETURN VARCHAR2
1515: IS
1516: cursor c_alternate IS
1517: SELECT alternate_bom_designator
1518: FROM bom_structures_b
1519: WHERE bill_sequence_id = p_bill_sequence_id;
1520: BEGIN
1521: for alternate in c_alternate
1522: loop

Line 1555: , bom_structures_b bsb

1551: CURSOR c_structure_type(l_bill_sequence_id NUMBER
1552: ) IS
1553: SELECT display_name
1554: FROM bom_structure_types_vl st
1555: , bom_structures_b bsb
1556: WHERE bsb.bill_sequence_id = l_bill_sequence_id
1557: and bsb.structure_type_id = st.structure_type_id;
1558:
1559: BEGIN

Line 1877: FROM Bom_Structures_b

1873: --If revision code is not passed then current revision will be queried.
1874: -- Commenting the revision related code, as structure change policies are not dependent on item's revision
1875: /*IF p_item_revision_code IS NULL THEN
1876: SELECT Assembly_Item_id, Organization_Id into l_item_id, l_org_id
1877: FROM Bom_Structures_b
1878: WHERE Bill_Sequence_Id = p_bill_seq_id;
1879: l_item_rev_code := BOM_REVISIONS.GET_ITEM_REVISION_FN('ALL', 'ALL', l_org_id, l_item_id, SYSDATE);
1880: END IF;
1881: */

Line 1886: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

1882: -- Getting the change policy value.
1883: SELECT
1884: ecp.policy_char_value INTO l_change_policy_char_val
1885: FROM
1886: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
1887: WHERE
1888: ecp.policy_object_pk1_value =
1889: (SELECT TO_CHAR(ic.item_catalog_group_id)
1890: FROM mtl_item_catalog_groups_b ic

Line 2365: FROM BOM_STRUCTURES_B

2361: WHERE revision_id = p_context_rev_id;
2362:
2363: SELECT effectivity_control
2364: INTO l_eff_ctrl
2365: FROM BOM_STRUCTURES_B
2366: WHERE bill_sequence_id = (SELECT bill_sequence_id
2367: FROM bom_components_b
2368: WHERE component_sequence_id = p_component_sequence_id
2369: AND ROWNUM = 1);

Line 2457: from BOM_STRUCTURES_B

2453:
2454: Cursor get_structure_type(p_bill_seq_id NUMBER)
2455: IS
2456: Select structure_type_id
2457: from BOM_STRUCTURES_B
2458: where bill_sequence_id = p_bill_seq_id;
2459:
2460: CURSOR C_DATA_LEVEL(p_data_level_name VARCHAR2) IS
2461: SELECT DATA_LEVEL_ID

Line 2547: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B

2543: --Get the new ComponentSequenceId
2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2545:
2546: --Get the parents effectivity control
2547: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2549:
2550: -- IF the effectivity is not of date or rev return
2551: IF l_effectivity_control = 1 THEN

Line 2992: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B

2988: l_start_effectivity_date DATE;
2989: l_rev_code VARCHAR2(30);
2990: BEGIN
2991: --Get the parents effectivity control
2992: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2993: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2994:
2995: -- IF the effectivity is not of date or rev return
2996: BEGIN

Line 3085: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;

3081:
3082: FUNCTION Get_Bill_Header_ECN(p_bill_seq_id IN NUMBER)
3083: RETURN VARCHAR2
3084: IS
3085: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;
3086: BEGIN
3087: SELECT pending_from_ecn
3088: INTO l_pend_from_ecn
3089: FROM bom_structures_b

Line 3089: FROM bom_structures_b

3085: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;
3086: BEGIN
3087: SELECT pending_from_ecn
3088: INTO l_pend_from_ecn
3089: FROM bom_structures_b
3090: WHERE bill_sequence_id = p_bill_Seq_id;
3091:
3092: IF l_pend_from_ecn IS NOT NULL
3093: THEN

Line 3335: FROM BOM_STRUCTURES_B

3331: BEGIN
3332:
3333: SELECT assembly_item_id, organization_id, structure_type_id
3334: INTO l_item_id, l_org_id, l_str_type_id
3335: FROM BOM_STRUCTURES_B
3336: WHERE bill_sequence_id = p_bill_seq_id;
3337:
3338: IF p_comp_seq_id IS NOT NULL --Component delete
3339: THEN