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 900: FROM csi_ii_relationships PR

896: WHERE id1 IN
897: (SELECT inventory_item_id FROM
898: csi_item_instances
899: WHERE instance_id IN (SELECT PR.object_id
900: FROM csi_ii_relationships PR
901: WHERE relationship_type_code = 'COMPONENT-OF'
902: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp
903: WHERE pr.object_id = cp.subject_id )))
904: AND IT.serviceable_product_flag = 'Y'

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

898: csi_item_instances
899: WHERE instance_id IN (SELECT PR.object_id
900: FROM csi_ii_relationships PR
901: WHERE relationship_type_code = 'COMPONENT-OF'
902: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp
903: WHERE pr.object_id = cp.subject_id )))
904: AND IT.serviceable_product_flag = 'Y'
905: --And IT.organization_id = p_organization_id
906: AND SYSDATE BETWEEN nvl(it.start_date_active, SYSDATE) AND nvl(it.end_date_active, SYSDATE) ;

Line 917: FROM csi_ii_relationships ciir

913: IS
914: SELECT ciir.object_id config_parent_id,
915: ciir.subject_id cp_id,
916: LEVEL
917: FROM csi_ii_relationships ciir
918: WHERE active_end_date IS NULL
919: START WITH subject_id
920: IN (SELECT ciir_pr.subject_id
921: FROM csi_ii_relationships ciir_pr

Line 921: FROM csi_ii_relationships ciir_pr

917: FROM csi_ii_relationships ciir
918: WHERE active_end_date IS NULL
919: START WITH subject_id
920: IN (SELECT ciir_pr.subject_id
921: FROM csi_ii_relationships ciir_pr
922: WHERE object_id IN
923: (SELECT instance_id
924: FROM csi_item_instances
925: WHERE inventory_item_id = p_inventory_id

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

959: AND CII.last_oe_order_line_id = OOL.line_id ( + )
960: AND CII.instance_status_id = CIS.instance_status_id
961: AND CIS.service_order_allowed_flag = 'Y' ;
962:
963: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := - 99;
964: l_config_rec l_csr_configuration%ROWTYPE;
965: l_model_prod_rec l_csr_model_products%ROWTYPE;
966: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;
967: l_inv_id NUMBER := - 99;

Line 993: ||' FROM csi_ii_relationships ciir '

989:
990: l_config_cust := 'SELECT ciir.object_id config_parent_id,'
991: ||'ciir.subject_id cp_id,'
992: ||'level '
993: ||' FROM csi_ii_relationships ciir '
994: ||' WHERE active_end_date IS NULL '
995: ||' START WITH subject_id '
996: ||' IN (SELECT ciir_pr.subject_id '
997: ||' FROM csi_ii_relationships ciir_pr '

Line 997: ||' FROM csi_ii_relationships ciir_pr '

993: ||' FROM csi_ii_relationships ciir '
994: ||' WHERE active_end_date IS NULL '
995: ||' START WITH subject_id '
996: ||' IN (SELECT ciir_pr.subject_id '
997: ||' FROM csi_ii_relationships ciir_pr '
998: ||' WHERE object_id IN '
999: ||' ( SELECT instance_id '
1000: ||' FROM csi_item_instances '
1001: ||' WHERE inventory_item_id = to_char(:l_id)'

Line 1011: ||' FROM csi_ii_relationships ciir '

1007:
1008: l_config_rel := 'SELECT ciir.object_id config_parent_id,'
1009: ||'ciir.subject_id cp_id,'
1010: ||'level '
1011: ||' FROM csi_ii_relationships ciir '
1012: ||' WHERE active_end_date IS NULL '
1013: ||' START WITH subject_id '
1014: ||' IN (SELECT ciir_pr.subject_id '
1015: ||' FROM csi_ii_relationships ciir_pr '

Line 1015: ||' FROM csi_ii_relationships ciir_pr '

1011: ||' FROM csi_ii_relationships ciir '
1012: ||' WHERE active_end_date IS NULL '
1013: ||' START WITH subject_id '
1014: ||' IN (SELECT ciir_pr.subject_id '
1015: ||' FROM csi_ii_relationships ciir_pr '
1016: ||' WHERE object_id IN '
1017: ||' ( SELECT instance_id '
1018: ||' FROM csi_item_instances '
1019: ||' WHERE inventory_item_id = to_char(:l_id ) '

Line 1035: ||' FROM csi_ii_relationships ciir '

1031:
1032: l_config_both := 'SELECT ciir.object_id config_parent_id,'
1033: ||'ciir.subject_id cp_id,'
1034: ||'level '
1035: ||' FROM csi_ii_relationships ciir '
1036: ||' WHERE active_end_date IS NULL '
1037: ||' START WITH subject_id '
1038: ||' IN (SELECT ciir_pr.subject_id '
1039: ||' FROM csi_ii_relationships ciir_pr '

Line 1039: ||' FROM csi_ii_relationships ciir_pr '

1035: ||' FROM csi_ii_relationships ciir '
1036: ||' WHERE active_end_date IS NULL '
1037: ||' START WITH subject_id '
1038: ||' IN (SELECT ciir_pr.subject_id '
1039: ||' FROM csi_ii_relationships ciir_pr '
1040: ||' WHERE object_id IN '
1041: ||' ( SELECT instance_id '
1042: ||' FROM csi_item_instances '
1043: ||' WHERE inventory_item_id = to_char(:l_id)'

Line 1062: ||' FROM csi_ii_relationships ciir '

1058:
1059: l_config_all := 'SELECT ciir.object_id config_parent_id,'
1060: ||'ciir.subject_id cp_id,'
1061: ||'level '
1062: ||' FROM csi_ii_relationships ciir '
1063: ||' WHERE active_end_date IS NULL '
1064: ||' START WITH subject_id '
1065: ||' IN (SELECT ciir_pr.subject_id '
1066: ||' FROM csi_ii_relationships ciir_pr '

Line 1066: ||' FROM csi_ii_relationships ciir_pr '

1062: ||' FROM csi_ii_relationships ciir '
1063: ||' WHERE active_end_date IS NULL '
1064: ||' START WITH subject_id '
1065: ||' IN (SELECT ciir_pr.subject_id '
1066: ||' FROM csi_ii_relationships ciir_pr '
1067: ||' WHERE object_id IN '
1068: ||' ( SELECT instance_id '
1069: ||' FROM csi_item_instances '
1070: ||' WHERE inventory_item_id = to_char(:l_id))) '

Line 1402: FROM csi_ii_relationships PR

1398: (SELECT inventory_item_id
1399: FROM csi_item_instances
1400: WHERE instance_id IN
1401: (SELECT PR.object_id
1402: FROM csi_ii_relationships PR
1403: WHERE relationship_type_code = 'COMPONENT-OF'
1404: AND NOT EXISTS
1405: (SELECT cp.subject_id
1406: FROM csi_ii_relationships cp

Line 1406: FROM csi_ii_relationships cp

1402: FROM csi_ii_relationships PR
1403: WHERE relationship_type_code = 'COMPONENT-OF'
1404: AND NOT EXISTS
1405: (SELECT cp.subject_id
1406: FROM csi_ii_relationships cp
1407: WHERE pr.object_id = cp.subject_id)))
1408: AND IT.serviceable_product_flag = 'Y'
1409: --And IT.organization_id = p_organization_id
1410: AND SYSDATE BETWEEN nvl(it.start_date_active, SYSDATE) AND

Line 1416: FROM csi_ii_relationships ciir

1412:
1413: /** get parent child hierarchy from csi_ii_realtionships **/
1414: CURSOR l_csr_configuration(p_inventory_id IN NUMBER, p_party_id IN NUMBER) IS
1415: SELECT ciir.object_id config_parent_id, ciir.subject_id cp_id, LEVEL
1416: FROM csi_ii_relationships ciir
1417: WHERE active_end_date IS NULL
1418: START WITH subject_id IN
1419: (SELECT ciir_pr.subject_id
1420: FROM csi_ii_relationships ciir_pr

Line 1420: FROM csi_ii_relationships ciir_pr

1416: FROM csi_ii_relationships ciir
1417: WHERE active_end_date IS NULL
1418: START WITH subject_id IN
1419: (SELECT ciir_pr.subject_id
1420: FROM csi_ii_relationships ciir_pr
1421: WHERE object_id IN
1422: (SELECT instance_id
1423: FROM csi_item_instances
1424: WHERE inventory_item_id = p_inventory_id

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

1456: AND CII.last_oe_order_line_id = OOL.line_id(+)
1457: AND CII.instance_status_id = CIS.instance_status_id
1458: AND CIS.service_order_allowed_flag = 'Y';
1459:
1460: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := -99;
1461: l_config_rec l_csr_configuration%ROWTYPE;
1462: l_model_prod_rec l_csr_model_products%ROWTYPE;
1463: l_id CSI_ITEM_INSTANCES.instance_id%TYPE;
1464: l_inv_id NUMBER := -99;

Line 1535: ' FROM csi_ii_relationships ciir ' ||

1531: /** Set up dynamic queries to fetch config items **/
1532:
1533: l_config_cust := 'SELECT ciir.object_id config_parent_id,' ||
1534: 'ciir.subject_id cp_id,' || 'level ' ||
1535: ' FROM csi_ii_relationships ciir ' ||
1536: ' WHERE active_end_date IS NULL ' ||
1537: ' START WITH subject_id ' ||
1538: ' IN (SELECT ciir_pr.subject_id ' ||
1539: ' FROM csi_ii_relationships ciir_pr ' ||

Line 1539: ' FROM csi_ii_relationships ciir_pr ' ||

1535: ' FROM csi_ii_relationships ciir ' ||
1536: ' WHERE active_end_date IS NULL ' ||
1537: ' START WITH subject_id ' ||
1538: ' IN (SELECT ciir_pr.subject_id ' ||
1539: ' FROM csi_ii_relationships ciir_pr ' ||
1540: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1541: ' FROM csi_item_instances ' ||
1542: ' WHERE instance_id = to_char(:l_id)' ||
1543: ' AND owner_party_account_id in (select id1 ' ||

Line 1550: ' FROM csi_ii_relationships ciir ' ||

1546: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';
1547:
1548: l_config_rel := 'SELECT ciir.object_id config_parent_id,' ||
1549: 'ciir.subject_id cp_id,' || 'level ' ||
1550: ' FROM csi_ii_relationships ciir ' ||
1551: ' WHERE active_end_date IS NULL ' ||
1552: ' START WITH subject_id ' ||
1553: ' IN (SELECT ciir_pr.subject_id ' ||
1554: ' FROM csi_ii_relationships ciir_pr ' ||

Line 1554: ' FROM csi_ii_relationships ciir_pr ' ||

1550: ' FROM csi_ii_relationships ciir ' ||
1551: ' WHERE active_end_date IS NULL ' ||
1552: ' START WITH subject_id ' ||
1553: ' IN (SELECT ciir_pr.subject_id ' ||
1554: ' FROM csi_ii_relationships ciir_pr ' ||
1555: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1556: ' FROM csi_item_instances ' ||
1557: ' WHERE instance_id = to_char(:l_id ) ' ||
1558: ' AND owner_party_account_id in ' ||

Line 1571: ' FROM csi_ii_relationships ciir ' ||

1567: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';
1568:
1569: l_config_both := 'SELECT ciir.object_id config_parent_id,' ||
1570: 'ciir.subject_id cp_id,' || 'level ' ||
1571: ' FROM csi_ii_relationships ciir ' ||
1572: ' WHERE active_end_date IS NULL ' ||
1573: ' START WITH subject_id ' ||
1574: ' IN (SELECT ciir_pr.subject_id ' ||
1575: ' FROM csi_ii_relationships ciir_pr ' ||

Line 1575: ' FROM csi_ii_relationships ciir_pr ' ||

1571: ' FROM csi_ii_relationships ciir ' ||
1572: ' WHERE active_end_date IS NULL ' ||
1573: ' START WITH subject_id ' ||
1574: ' IN (SELECT ciir_pr.subject_id ' ||
1575: ' FROM csi_ii_relationships ciir_pr ' ||
1576: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1577: ' FROM csi_item_instances ' ||
1578: ' WHERE instance_id = to_char(:l_id)' ||
1579: ' AND owner_party_account_id in ((select id1 ' ||

Line 1594: ' FROM csi_ii_relationships ciir ' ||

1590: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';
1591:
1592: l_config_all := 'SELECT ciir.object_id config_parent_id,' ||
1593: 'ciir.subject_id cp_id,' || 'level ' ||
1594: ' FROM csi_ii_relationships ciir ' ||
1595: ' WHERE active_end_date IS NULL ' ||
1596: ' START WITH subject_id ' ||
1597: ' IN (SELECT ciir_pr.subject_id ' ||
1598: ' FROM csi_ii_relationships ciir_pr ' ||

Line 1598: ' FROM csi_ii_relationships ciir_pr ' ||

1594: ' FROM csi_ii_relationships ciir ' ||
1595: ' WHERE active_end_date IS NULL ' ||
1596: ' START WITH subject_id ' ||
1597: ' IN (SELECT ciir_pr.subject_id ' ||
1598: ' FROM csi_ii_relationships ciir_pr ' ||
1599: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1600: ' FROM csi_item_instances ' ||
1601: ' WHERE instance_id = to_char(:l_id))) ' ||
1602: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';