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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on POS_PRODUCTS_SERVICES_GT

Line 1074: from pos_products_services_gt

1070: ' AND mcb.category_id = mcsvc.category_id
1071: and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'')
1072: AND mcsvc.category_set_id =' || g_default_po_category_set_id ||
1073: ' AND ffvl.flex_value = mcb.' || p_column_name || ' and not exists (select SEGMENT_VALUE_ID
1074: from pos_products_services_gt
1075: where SEGMENT_VALUE_ID = ffvl.flex_value_id )';
1076:
1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.pos_product_service_utl_pkg.insert_into_glb_temp.begin', 'l_tbl_sql (I) : '||l_tbl_sql);

Line 1086: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;

1082: loop
1083: FETCH l_tblcur INTO l_value , l_description , l_value_id ;
1084:
1085: EXIT WHEN l_tblcur%NOTFOUND;
1086: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;
1087: IF(l_count = 0) THEN
1088:
1089: insert into pos_products_services_gt(SEGMENT_VALUE ,
1090: SEGMENT_VALUE_DESCRIPTION ,

Line 1089: insert into pos_products_services_gt(SEGMENT_VALUE ,

1085: EXIT WHEN l_tblcur%NOTFOUND;
1086: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;
1087: IF(l_count = 0) THEN
1088:
1089: insert into pos_products_services_gt(SEGMENT_VALUE ,
1090: SEGMENT_VALUE_DESCRIPTION ,
1091: SUPPLIER_SELECTION ,
1092: PARENT_SEGMENT_VALUE ,
1093: PARENT_SEGMENT_VALUE_ID ,

Line 1158: from pos_products_services_gt

1154: ffvl2.flex_value = mcb1.'|| p_column_name || ' and
1155: ffvl2.parent_flex_value_low = mcb1.'|| p_parent_column_name || ' and
1156: ffvl2.parent_flex_value_low = '||'''' || l_parent_value || '''' ||' and
1157: not exists (select SEGMENT_VALUE_ID
1158: from pos_products_services_gt
1159: where SEGMENT_VALUE_ID = ffvl2.flex_value_id)' ;
1160:
1161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1171: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;

1167: loop
1168: FETCH l_tblcur INTO l_value , l_description , l_value_id ;
1169:
1170: EXIT WHEN l_tblcur%NOTFOUND;
1171: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;
1172: IF(l_count = 0) THEN
1173: insert into pos_products_services_gt(SEGMENT_VALUE ,
1174: SEGMENT_VALUE_DESCRIPTION ,
1175: SUPPLIER_SELECTION ,

Line 1173: insert into pos_products_services_gt(SEGMENT_VALUE ,

1169:
1170: EXIT WHEN l_tblcur%NOTFOUND;
1171: select Count(*) INTO l_count FROM pos_products_services_gt WHERE SEGMENT_VALUE_ID = l_value_id ;
1172: IF(l_count = 0) THEN
1173: insert into pos_products_services_gt(SEGMENT_VALUE ,
1174: SEGMENT_VALUE_DESCRIPTION ,
1175: SUPPLIER_SELECTION ,
1176: PARENT_SEGMENT_VALUE ,
1177: PARENT_SEGMENT_VALUE_ID ,

Line 1224: To_Char(x.value) = mcb.'||p_column_name|| ' AND NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = x.value ) ';

1220: ') x where mcb.' || p_column_name ||' is not null
1221: and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y''
1222: or mcb.supplier_enabled_flag = ''y'')
1223: and mcb.category_id = mcsvc.category_id and mcsvc.category_set_id ='||g_default_po_category_set_id || ' and
1224: To_Char(x.value) = mcb.'||p_column_name|| ' AND NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = x.value ) ';
1225:
1226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.pos_product_service_utl_pkg.insert_into_glb_temp.begin', 'l_tbl_sql (T1) : '||l_tbl_sql);
1228: END IF;

Line 1241: ' and NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = x.value ) ';

1237: or mcb.supplier_enabled_flag = ''y'')
1238: and mcb.category_id = mcsvc.category_id and mcsvc.category_set_id ='||g_default_po_category_set_id || ' and
1239: To_Char(x.value) = mcb.'||p_column_name||
1240:
1241: ' and NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = x.value ) ';
1242:
1243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.pos_product_service_utl_pkg.insert_into_glb_temp.begin', 'l_tbl_sql (T2) : '||l_tbl_sql);
1245: END IF;

Line 1253: insert into pos_products_services_gt(SEGMENT_VALUE ,

1249: OPEN l_tblcur for l_tbl_sql;
1250: loop
1251: FETCH l_tblcur INTO l_value , l_description;
1252: EXIT WHEN l_tblcur%NOTFOUND;
1253: insert into pos_products_services_gt(SEGMENT_VALUE ,
1254: SEGMENT_VALUE_DESCRIPTION ,
1255: SUPPLIER_SELECTION ,
1256: PARENT_SEGMENT_VALUE ,
1257: PARENT_SEGMENT_VALUE_ID ,

Line 1301: FROM pos_products_services_gt

1297: l_contact_description VARCHAR2(4000) := null;
1298: l_segment_value_description VARCHAR2(240) := null;
1299: CURSOR c1 IS
1300: SELECT SEGMENT_VALUE_DESCRIPTION
1301: FROM pos_products_services_gt
1302: START WITH segment_value_id = x_segment_value_id
1303: CONNECT BY PRIOR parent_segment_value_id =segment_value_id
1304: ORDER BY parent_segment_value_id DESC;
1305:

Line 1332: FROM pos_products_services_gt

1328: l_contact_code VARCHAR2(4000) := null;
1329: l_segment_value_code VARCHAR2(240) := null;
1330: CURSOR c1 IS
1331: SELECT SEGMENT_VALUE
1332: FROM pos_products_services_gt
1333: START WITH segment_value_id = x_segment_value_id
1334: CONNECT BY PRIOR parent_segment_value_id =segment_value_id
1335: ORDER BY parent_segment_value_id DESC;
1336: