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.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_LINES

Line 1095: FROM ozf_resale_lines_int lin

1091: ,cv_account_id NUMBER) IS
1092: SELECT MAX(pt_cnt)
1093: FROM (
1094: SELECT COUNT(orig_system_item_number) pt_cnt
1095: FROM ozf_resale_lines_int lin
1096: ,ozf_resale_batches bat
1097: WHERE lin.resale_batch_id = bat.resale_batch_id
1098: AND orig_system_item_number = cv_external_code
1099: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)

Line 1102: FROM ozf_resale_lines lin

1098: AND orig_system_item_number = cv_external_code
1099: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1100: UNION
1101: SELECT COUNT(orig_system_item_number) pt_cnt
1102: FROM ozf_resale_lines lin
1103: ,ozf_resale_batches bat
1104: ,ozf_resale_batch_line_maps map
1105: WHERE orig_system_item_number = cv_external_code
1106: AND lin.resale_line_id = map.resale_line_id

Line 1114: FROM ozf_resale_lines_int lin

1110:
1111: CURSOR csr_code_conv_product (cv_external_code VARCHAR2)
1112: IS
1113: SELECT COUNT(orig_system_item_number)
1114: FROM ozf_resale_lines_int lin
1115: WHERE orig_system_item_number = cv_external_code;
1116:
1117: CURSOR csr_code_conv_agreement_pt (cv_external_code VARCHAR2
1118: ,cv_party_id NUMBER

Line 1125: FROM ozf_resale_lines_int lin

1121: SELECT MAX(pt_cnt)
1122: FROM
1123: (
1124: SELECT COUNT(orig_system_agreement_name) pt_cnt
1125: FROM ozf_resale_lines_int lin
1126: ,ozf_resale_batches bat
1127: WHERE lin.resale_batch_id = bat.resale_batch_id
1128: AND orig_system_agreement_name = cv_external_code
1129: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)

Line 1140: FROM ozf_resale_lines_int lin

1136: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;
1137:
1138: CURSOR csr_code_conv_agreement (cv_external_code VARCHAR2) IS
1139: SELECT COUNT(orig_system_agreement_name)
1140: FROM ozf_resale_lines_int lin
1141: WHERE orig_system_agreement_name = cv_external_code;
1142:
1143: CURSOR csr_code_conv_agrmt_uom (cv_external_code VARCHAR2
1144: ,cv_party_id NUMBER

Line 1226: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1222:
1223:
1224: IF G_PARTY_ID IS NOT NULL THEN
1225:
1226: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1227: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1228: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1229: l_sql := l_sql|| 'AND '||l_where ||') ';
1230:

Line 1231: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||

1227: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1228: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1229: l_sql := l_sql|| 'AND '||l_where ||') ';
1230:
1231: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1232: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1233: l_interface_sql := l_interface_sql ||' AND '||l_where || 'OR orig_system_agreement_uom = :1 )';
1234:
1235:

Line 1246: l_sql := l_sql ||' ozf_resale_lines WHERE';

1242: END IF;
1243:
1244:
1245: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1246: l_sql := l_sql ||' ozf_resale_lines WHERE';
1247: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1248: l_sql := l_sql || l_where ||') ';
1249: l_interface_sql := l_interface_sql ||l_where ||
1250: 'OR orig_system_agreement_uom = :1 )';

Line 1247: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';

1243:
1244:
1245: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1246: l_sql := l_sql ||' ozf_resale_lines WHERE';
1247: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1248: l_sql := l_sql || l_where ||') ';
1249: l_interface_sql := l_interface_sql ||l_where ||
1250: 'OR orig_system_agreement_uom = :1 )';
1251:

Line 1417: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1413: ' OR ship_to_party_name = :1 )';
1414:
1415:
1416: IF G_PARTY_ID IS NOT NULL THEN
1417: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1418: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1419: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1420:
1421: l_where := l_where||' AND bat.partner_party_id = :2 ' ;

Line 1431: l_sql := l_sql ||' ozf_resale_lines WHERE';

1427: l_sql := l_sql || 'AND '||l_where;
1428: l_interface_sql := l_interface_sql ||'AND '|| l_where;
1429:
1430: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1431: l_sql := l_sql ||' ozf_resale_lines WHERE';
1432: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1433: l_sql := l_sql || l_where;
1434: l_interface_sql := l_interface_sql || l_where;
1435: END IF;

Line 1432: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';

1428: l_interface_sql := l_interface_sql ||'AND '|| l_where;
1429:
1430: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1431: l_sql := l_sql ||' ozf_resale_lines WHERE';
1432: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1433: l_sql := l_sql || l_where;
1434: l_interface_sql := l_interface_sql || l_where;
1435: END IF;
1436: for i in 1..ceil((length(l_sql)/100)) loop

Line 1508: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1504: ' OR ship_to_location = :1 )';
1505:
1506: -- fix for 5226248
1507: IF G_PARTY_ID IS NOT NULL THEN
1508: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1509: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1510: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1511: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1512: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';

Line 1509: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||

1505:
1506: -- fix for 5226248
1507: IF G_PARTY_ID IS NOT NULL THEN
1508: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1509: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1510: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1511: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1512: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1513:

Line 1524: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';

1520: l_sql := l_sql || 'AND '||l_where;
1521: l_interface_sql := l_interface_sql || 'AND '||l_where;
1522:
1523: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1524: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1525: l_sql := l_sql ||' ozf_resale_lines WHERE';
1526: l_sql := l_sql || l_where;
1527: l_interface_sql := l_interface_sql || l_where;
1528: END IF;

Line 1525: l_sql := l_sql ||' ozf_resale_lines WHERE';

1521: l_interface_sql := l_interface_sql || 'AND '||l_where;
1522:
1523: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1524: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1525: l_sql := l_sql ||' ozf_resale_lines WHERE';
1526: l_sql := l_sql || l_where;
1527: l_interface_sql := l_interface_sql || l_where;
1528: END IF;
1529: