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 2452: from BOM_STRUCTURES_B

2448:
2449: Cursor get_structure_type(p_bill_seq_id NUMBER)
2450: IS
2451: Select structure_type_id
2452: from BOM_STRUCTURES_B
2453: where bill_sequence_id = p_bill_seq_id;
2454:
2455: BEGIN
2456:

Line 2509: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B

2505: --Get the new ComponentSequenceId
2506: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2507:
2508: --Get the parents effectivity control
2509: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2510: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2511:
2512: -- IF the effectivity is not of date or rev return
2513: IF l_effectivity_control = 1 THEN

Line 2949: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B

2945: l_start_effectivity_date DATE;
2946: l_rev_code VARCHAR2(30);
2947: BEGIN
2948: --Get the parents effectivity control
2949: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2950: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2951:
2952: -- IF the effectivity is not of date or rev return
2953: BEGIN

Line 3042: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;

3038:
3039: FUNCTION Get_Bill_Header_ECN(p_bill_seq_id IN NUMBER)
3040: RETURN VARCHAR2
3041: IS
3042: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;
3043: BEGIN
3044: SELECT pending_from_ecn
3045: INTO l_pend_from_ecn
3046: FROM bom_structures_b

Line 3046: FROM bom_structures_b

3042: l_pend_from_ecn BOM_STRUCTURES_B.pending_from_ecn%TYPE;
3043: BEGIN
3044: SELECT pending_from_ecn
3045: INTO l_pend_from_ecn
3046: FROM bom_structures_b
3047: WHERE bill_sequence_id = p_bill_Seq_id;
3048:
3049: IF l_pend_from_ecn IS NOT NULL
3050: THEN

Line 3272: FROM BOM_STRUCTURES_B

3268: BEGIN
3269:
3270: SELECT assembly_item_id, organization_id, structure_type_id
3271: INTO l_item_id, l_org_id, l_str_type_id
3272: FROM BOM_STRUCTURES_B
3273: WHERE bill_sequence_id = p_bill_seq_id;
3274:
3275: IF p_comp_seq_id IS NOT NULL --Component delete
3276: THEN