APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_ASSOCIATIONS_V

Line 522: FROM AHL_ITEM_ASSOCIATIONS_VL

518: CURSOR item_revnotnull_csr(p_item_group_id IN NUMBER,
519: p_inventory_item_id IN NUMBER,
520: p_inventory_org_id IN NUMBER) IS
521: SELECT REVISION
522: FROM AHL_ITEM_ASSOCIATIONS_VL
523: WHERE item_group_id = p_item_group_id
524: AND inventory_org_id = ( Select master_organization_id
525: from mtl_parameters
526: where organization_id = p_inventory_org_id)

Line 535: FROM AHL_ITEM_ASSOCIATIONS_VL

531: p_inventory_item_id IN NUMBER,
532: p_item_revision IN VARCHAR2,
533: p_inventory_org_id IN NUMBER) IS
534: SELECT 'x'
535: FROM AHL_ITEM_ASSOCIATIONS_VL
536: WHERE item_group_id = p_item_group_id
537: --AND (REVISION IS NULL OR REVISION = p_item_revision)
538: AND (REVISION IS NULL)
539: AND inventory_org_id = ( Select master_organization_id

Line 551: FROM AHL_ITEM_ASSOCIATIONS_VL

547: p_inventory_item_id IN NUMBER,
548: p_inventory_org_id IN NUMBER,
549: p_item_revision IN VARCHAR2) IS
550: SELECT 'x'
551: FROM AHL_ITEM_ASSOCIATIONS_VL
552: WHERE item_group_id = p_item_group_id
553: AND (REVISION = p_item_revision)
554: AND inventory_org_id = (Select master_organization_id
555: from mtl_parameters

Line 618: AHL_ITEM_ASSOCIATIONS_VL

614: SELECT 'x'
615: INTO
616: l_junk
617: FROM
618: AHL_ITEM_ASSOCIATIONS_VL
619: WHERE
620: item_group_id = p_item_group_id
621: AND inventory_org_id = (Select master_organization_id
622: from mtl_parameters

Line 671: FROM AHL_ITEM_ASSOCIATIONS_VL

667: p_inventory_item_id IN NUMBER,
668: p_item_revision IN VARCHAR2,
669: p_inventory_org_id IN NUMBER) IS
670: SELECT 'x'
671: FROM AHL_ITEM_ASSOCIATIONS_VL
672: WHERE item_group_id = p_item_group_id
673: AND NVL(REVISION,'000') = p_item_revision
674: AND inventory_org_id = ( Select master_organization_id
675: from mtl_parameters

Line 893: FROM AHL_ITEM_ASSOCIATIONS_V

889: revision_qty_cntrl_code,
890: serial_nbr_cntrl_code ,
891: organization_code,
892: REVISION
893: FROM AHL_ITEM_ASSOCIATIONS_V
894: WHERE item_association_id = p_item_assoc_id;
895:
896: l_item_assoc_rec Item_assoc_csr%ROWTYPE;
897: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

Line 1686: FROM ahl_item_associations_vl

1682:
1683: CURSOR Item_assoc_csr(p_row_id UROWID) IS
1684: SELECT
1685: Object_version_number
1686: FROM ahl_item_associations_vl
1687: WHERE row_id = p_row_id
1688: FOR UPDATE OF object_version_number NOWAIT;
1689:
1690: l_object_version_number NUMBER;

Line 2852: Where exists ( select item_association_id from ahl_item_associations_vl

2848:
2849: CURSOR validate_item_group(c_itemgroup_id NUMBER)
2850: is
2851: Select 'x' from dual
2852: Where exists ( select item_association_id from ahl_item_associations_vl
2853: Where Item_Group_id = c_itemgroup_id and
2854: INTERCHANGE_TYPE_CODE in ('1-WAY INTERCHANGEABLE','2-WAY INTERCHANGEABLE') );
2855:
2856: CURSOR validate_item_group_positions(c_itemgroup_id NUMBER)

Line 3251: from ahl_item_associations_vl

3247: attribute12 ,
3248: attribute13 ,
3249: attribute14 ,
3250: attribute15
3251: from ahl_item_associations_vl
3252: where item_group_id = c_itemgroup_id;
3253:
3254:
3255: cursor get_revision_info(c_itemgroup_id in Number)

Line 3592: from ahl_item_associations_vl

3588: attribute12 ,
3589: attribute13 ,
3590: attribute14 ,
3591: attribute15
3592: from ahl_item_associations_vl
3593: where item_group_id = c_itemgroup_id;
3594: --
3595:
3596: l_version_number NUMBER;

Line 3886: from ahl_item_associations_vl

3882: attribute12 ,
3883: attribute13 ,
3884: attribute14 ,
3885: attribute15
3886: from ahl_item_associations_vl
3887: where item_group_id = c_itemgroup_id;
3888:
3889:
3890: l_status VARCHAR2(30);