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.PO_CATALOG_INDEX_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 933: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs

929: OR
930: EXISTS
931: (
932: SELECT 'last update date of po_lines is greater than ip record'
933: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs
934: WHERE hdrs.PO_LINE_ID = POL.PO_LINE_ID
935: AND POL.last_update_date > hdrs.last_update_date )
936: --Bug 13343886
937: OR NOT EXISTS

Line 939: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID

935: AND POL.last_update_date > hdrs.last_update_date )
936: --Bug 13343886
937: OR NOT EXISTS
938: (
939: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID
940: ) --Bug 13343886
941: );
942:
943: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

Line 1038: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs

1034: OR
1035: EXISTS
1036: (
1037: SELECT 'last update date of po_attribute greater than ip record'
1038: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs
1039: WHERE hdrs.PO_LINE_ID = POL.PO_LINE_ID
1040: AND POATR.last_update_date > hdrs.last_update_date )
1041: --Bug 13343886
1042: OR NOT EXISTS

Line 1044: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID

1040: AND POATR.last_update_date > hdrs.last_update_date )
1041: --Bug 13343886
1042: OR NOT EXISTS
1043: (
1044: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID
1045: ) --Bug 13343886
1046: );
1047:
1048:

Line 1144: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs

1140: OR
1141: EXISTS
1142: (
1143: SELECT 'last update date of po_attribute tlp greater than ip rec'
1144: FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs
1145: WHERE hdrs.PO_LINE_ID = POL.PO_LINE_ID
1146: AND POTLP.last_update_date > hdrs.last_update_date )
1147: --Bug 13343886
1148: OR NOT EXISTS

Line 1150: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID

1146: AND POTLP.last_update_date > hdrs.last_update_date )
1147: --Bug 13343886
1148: OR NOT EXISTS
1149: (
1150: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID
1151: ) --Bug 13343886
1152: );
1153:
1154: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;