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.OKS_AUTH_UTIL_PVT dependencies on CSI_II_RELATIONSHIPS

Line 817: FROM csi_ii_relationships PR

813: WHERE id1 IN
814: (SELECT inventory_item_id FROM
815: csi_item_instances
816: WHERE instance_id IN (SELECT PR.object_id
817: FROM csi_ii_relationships PR
818: WHERE relationship_type_code = 'COMPONENT-OF'
819: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp
820: WHERE pr.object_id = cp.subject_id )))
821: AND IT.serviceable_product_flag = 'Y'

Line 819: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp

815: csi_item_instances
816: WHERE instance_id IN (SELECT PR.object_id
817: FROM csi_ii_relationships PR
818: WHERE relationship_type_code = 'COMPONENT-OF'
819: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp
820: WHERE pr.object_id = cp.subject_id )))
821: AND IT.serviceable_product_flag = 'Y'
822: --And IT.organization_id = p_organization_id
823: AND SYSDATE BETWEEN nvl(it.start_date_active, SYSDATE) AND nvl(it.end_date_active, SYSDATE) ;

Line 834: FROM csi_ii_relationships ciir

830: IS
831: SELECT ciir.object_id config_parent_id,
832: ciir.subject_id cp_id,
833: LEVEL
834: FROM csi_ii_relationships ciir
835: WHERE active_end_date IS NULL
836: START WITH subject_id
837: IN (SELECT ciir_pr.subject_id
838: FROM csi_ii_relationships ciir_pr

Line 838: FROM csi_ii_relationships ciir_pr

834: FROM csi_ii_relationships ciir
835: WHERE active_end_date IS NULL
836: START WITH subject_id
837: IN (SELECT ciir_pr.subject_id
838: FROM csi_ii_relationships ciir_pr
839: WHERE object_id IN
840: (SELECT instance_id
841: FROM csi_item_instances
842: WHERE inventory_item_id = p_inventory_id

Line 880: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := - 99;

876: AND CII.last_oe_order_line_id = OOL.line_id ( + )
877: AND CII.instance_status_id = CIS.instance_status_id
878: AND CIS.service_order_allowed_flag = 'Y' ;
879:
880: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := - 99;
881: l_config_rec l_csr_configuration%ROWTYPE;
882: l_model_prod_rec l_csr_model_products%ROWTYPE;
883: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;
884: l_inv_id NUMBER := - 99;

Line 910: ||' FROM csi_ii_relationships ciir '

906:
907: l_config_cust := 'SELECT ciir.object_id config_parent_id,'
908: ||'ciir.subject_id cp_id,'
909: ||'level '
910: ||' FROM csi_ii_relationships ciir '
911: ||' WHERE active_end_date IS NULL '
912: ||' START WITH subject_id '
913: ||' IN (SELECT ciir_pr.subject_id '
914: ||' FROM csi_ii_relationships ciir_pr '

Line 914: ||' FROM csi_ii_relationships ciir_pr '

910: ||' FROM csi_ii_relationships ciir '
911: ||' WHERE active_end_date IS NULL '
912: ||' START WITH subject_id '
913: ||' IN (SELECT ciir_pr.subject_id '
914: ||' FROM csi_ii_relationships ciir_pr '
915: ||' WHERE object_id IN '
916: ||' ( SELECT instance_id '
917: ||' FROM csi_item_instances '
918: ||' WHERE inventory_item_id = to_char(:l_id)'

Line 928: ||' FROM csi_ii_relationships ciir '

924:
925: l_config_rel := 'SELECT ciir.object_id config_parent_id,'
926: ||'ciir.subject_id cp_id,'
927: ||'level '
928: ||' FROM csi_ii_relationships ciir '
929: ||' WHERE active_end_date IS NULL '
930: ||' START WITH subject_id '
931: ||' IN (SELECT ciir_pr.subject_id '
932: ||' FROM csi_ii_relationships ciir_pr '

Line 932: ||' FROM csi_ii_relationships ciir_pr '

928: ||' FROM csi_ii_relationships ciir '
929: ||' WHERE active_end_date IS NULL '
930: ||' START WITH subject_id '
931: ||' IN (SELECT ciir_pr.subject_id '
932: ||' FROM csi_ii_relationships ciir_pr '
933: ||' WHERE object_id IN '
934: ||' ( SELECT instance_id '
935: ||' FROM csi_item_instances '
936: ||' WHERE inventory_item_id = to_char(:l_id ) '

Line 952: ||' FROM csi_ii_relationships ciir '

948:
949: l_config_both := 'SELECT ciir.object_id config_parent_id,'
950: ||'ciir.subject_id cp_id,'
951: ||'level '
952: ||' FROM csi_ii_relationships ciir '
953: ||' WHERE active_end_date IS NULL '
954: ||' START WITH subject_id '
955: ||' IN (SELECT ciir_pr.subject_id '
956: ||' FROM csi_ii_relationships ciir_pr '

Line 956: ||' FROM csi_ii_relationships ciir_pr '

952: ||' FROM csi_ii_relationships ciir '
953: ||' WHERE active_end_date IS NULL '
954: ||' START WITH subject_id '
955: ||' IN (SELECT ciir_pr.subject_id '
956: ||' FROM csi_ii_relationships ciir_pr '
957: ||' WHERE object_id IN '
958: ||' ( SELECT instance_id '
959: ||' FROM csi_item_instances '
960: ||' WHERE inventory_item_id = to_char(:l_id)'

Line 979: ||' FROM csi_ii_relationships ciir '

975:
976: l_config_all := 'SELECT ciir.object_id config_parent_id,'
977: ||'ciir.subject_id cp_id,'
978: ||'level '
979: ||' FROM csi_ii_relationships ciir '
980: ||' WHERE active_end_date IS NULL '
981: ||' START WITH subject_id '
982: ||' IN (SELECT ciir_pr.subject_id '
983: ||' FROM csi_ii_relationships ciir_pr '

Line 983: ||' FROM csi_ii_relationships ciir_pr '

979: ||' FROM csi_ii_relationships ciir '
980: ||' WHERE active_end_date IS NULL '
981: ||' START WITH subject_id '
982: ||' IN (SELECT ciir_pr.subject_id '
983: ||' FROM csi_ii_relationships ciir_pr '
984: ||' WHERE object_id IN '
985: ||' ( SELECT instance_id '
986: ||' FROM csi_item_instances '
987: ||' WHERE inventory_item_id = to_char(:l_id))) '