APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 723: AHL_UNIT_CONFIG_HEADERS AUCH

719: SELECT DISTINCT
720: AMH.MC_HEADER_ID
721: FROM
722: AHL_MC_HEADERS_VL AMH,
723: AHL_UNIT_CONFIG_HEADERS AUCH
724: WHERE
725: AMH.MC_HEADER_ID = AUCH.MASTER_CONFIG_ID AND
726: AUCH.CSI_ITEM_INSTANCE_ID IN (
727: SELECT SUBJECT_ID /* INSTANCE_ID OF ALL CHILD NODES (INCLUDING RECURSIVE NODES FROM SUB-CONFIG.) */

Line 732: FROM AHL_UNIT_CONFIG_HEADERS

728: FROM CSI_II_RELATIONSHIPS
729: WHERE NVL(ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE
730: START WITH OBJECT_ID IN
731: (SELECT CSI_ITEM_INSTANCE_ID /*PARENT NODE INSTANCEID */
732: FROM AHL_UNIT_CONFIG_HEADERS
733: WHERE NAME = c_unit_name) /*:UC_NAME */
734: CONNECT BY PRIOR SUBJECT_ID = OBJECT_ID
735: UNION
736: SELECT /*PARENT NODE INSTANCEID */

Line 739: AHL_UNIT_CONFIG_HEADERS

735: UNION
736: SELECT /*PARENT NODE INSTANCEID */
737: CSI_ITEM_INSTANCE_ID
738: FROM
739: AHL_UNIT_CONFIG_HEADERS
740: WHERE
741: NAME = c_unit_name ) AND
742: AMH.MC_HEADER_ID = c_mc_header_id ;
743: CURSOR Get_rec_from_value (c_unit_name VARCHAR2, c_mc_name VARCHAR2)

Line 749: AHL_UNIT_CONFIG_HEADERS AUCH

745: SELECT DISTINCT
746: AMH.MC_HEADER_ID
747: FROM
748: AHL_MC_HEADERS_VL AMH,
749: AHL_UNIT_CONFIG_HEADERS AUCH
750: WHERE
751: AMH.MC_HEADER_ID = AUCH.MASTER_CONFIG_ID AND
752: AUCH.CSI_ITEM_INSTANCE_ID IN (
753: SELECT SUBJECT_ID /* INSTANCE_ID OF ALL CHILD NODES (INCLUDING RECURSIVE NODES FROM SUB-CONFIG.) */

Line 758: FROM AHL_UNIT_CONFIG_HEADERS

754: FROM CSI_II_RELATIONSHIPS
755: WHERE NVL(ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE
756: START WITH OBJECT_ID IN
757: (SELECT CSI_ITEM_INSTANCE_ID /*PARENT NODE INSTANCEID */
758: FROM AHL_UNIT_CONFIG_HEADERS
759: WHERE NAME = c_unit_name) /*:UC_NAME */
760: CONNECT BY PRIOR SUBJECT_ID = OBJECT_ID
761: UNION
762: SELECT /*PARENT NODE INSTANCEID */

Line 765: AHL_UNIT_CONFIG_HEADERS

761: UNION
762: SELECT /*PARENT NODE INSTANCEID */
763: CSI_ITEM_INSTANCE_ID
764: FROM
765: AHL_UNIT_CONFIG_HEADERS
766: WHERE
767: NAME = c_unit_name ) AND
768: AMH.NAME = c_mc_name ;
769: l_unit_name VARCHAR2(80);