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 1082: FROM ozf_resale_lines_int lin

1078: ,cv_account_id NUMBER) IS
1079: SELECT MAX(pt_cnt)
1080: FROM (
1081: SELECT COUNT(orig_system_item_number) pt_cnt
1082: FROM ozf_resale_lines_int lin
1083: ,ozf_resale_batches bat
1084: WHERE lin.resale_batch_id = bat.resale_batch_id
1085: AND orig_system_item_number = cv_external_code
1086: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)

Line 1089: FROM ozf_resale_lines lin

1085: AND orig_system_item_number = cv_external_code
1086: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1087: UNION
1088: SELECT COUNT(orig_system_item_number) pt_cnt
1089: FROM ozf_resale_lines lin
1090: ,ozf_resale_batches bat
1091: ,ozf_resale_batch_line_maps map
1092: WHERE orig_system_item_number = cv_external_code
1093: AND lin.resale_line_id = map.resale_line_id

Line 1101: FROM ozf_resale_lines_int lin

1097:
1098: CURSOR csr_code_conv_product (cv_external_code VARCHAR2)
1099: IS
1100: SELECT COUNT(orig_system_item_number)
1101: FROM ozf_resale_lines_int lin
1102: WHERE orig_system_item_number = cv_external_code;
1103:
1104: CURSOR csr_code_conv_agreement_pt (cv_external_code VARCHAR2
1105: ,cv_party_id NUMBER

Line 1112: FROM ozf_resale_lines_int lin

1108: SELECT MAX(pt_cnt)
1109: FROM
1110: (
1111: SELECT COUNT(orig_system_agreement_name) pt_cnt
1112: FROM ozf_resale_lines_int lin
1113: ,ozf_resale_batches bat
1114: WHERE lin.resale_batch_id = bat.resale_batch_id
1115: AND orig_system_agreement_name = cv_external_code
1116: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)

Line 1127: FROM ozf_resale_lines_int lin

1123: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;
1124:
1125: CURSOR csr_code_conv_agreement (cv_external_code VARCHAR2) IS
1126: SELECT COUNT(orig_system_agreement_name)
1127: FROM ozf_resale_lines_int lin
1128: WHERE orig_system_agreement_name = cv_external_code;
1129:
1130: CURSOR csr_code_conv_agrmt_uom (cv_external_code VARCHAR2
1131: ,cv_party_id NUMBER

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

1209:
1210:
1211: IF G_PARTY_ID IS NOT NULL THEN
1212:
1213: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1214: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1215: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1216: l_sql := l_sql|| 'AND '||l_where ||') ';
1217:

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

1214: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1215: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1216: l_sql := l_sql|| 'AND '||l_where ||') ';
1217:
1218: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1219: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1220: l_interface_sql := l_interface_sql ||' AND '||l_where || 'OR orig_system_agreement_uom = :1 )';
1221:
1222:

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

1229: END IF;
1230:
1231:
1232: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1233: l_sql := l_sql ||' ozf_resale_lines WHERE';
1234: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1235: l_sql := l_sql || l_where ||') ';
1236: l_interface_sql := l_interface_sql ||l_where ||
1237: 'OR orig_system_agreement_uom = :1 )';

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

1230:
1231:
1232: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1233: l_sql := l_sql ||' ozf_resale_lines WHERE';
1234: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1235: l_sql := l_sql || l_where ||') ';
1236: l_interface_sql := l_interface_sql ||l_where ||
1237: 'OR orig_system_agreement_uom = :1 )';
1238:

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

1400: ' OR ship_to_party_name = :1 )';
1401:
1402:
1403: IF G_PARTY_ID IS NOT NULL THEN
1404: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1405: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1406: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1407:
1408: l_where := l_where||' AND bat.partner_party_id = :2 ' ;

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

1414: l_sql := l_sql || 'AND '||l_where;
1415: l_interface_sql := l_interface_sql ||'AND '|| l_where;
1416:
1417: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1418: l_sql := l_sql ||' ozf_resale_lines WHERE';
1419: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1420: l_sql := l_sql || l_where;
1421: l_interface_sql := l_interface_sql || l_where;
1422: END IF;

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

1415: l_interface_sql := l_interface_sql ||'AND '|| l_where;
1416:
1417: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1418: l_sql := l_sql ||' ozf_resale_lines WHERE';
1419: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1420: l_sql := l_sql || l_where;
1421: l_interface_sql := l_interface_sql || l_where;
1422: END IF;
1423: for i in 1..ceil((length(l_sql)/100)) loop

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

1491: ' OR ship_to_location = :1 )';
1492:
1493: -- fix for 5226248
1494: IF G_PARTY_ID IS NOT NULL THEN
1495: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1496: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1497: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1498: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1499: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';

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

1492:
1493: -- fix for 5226248
1494: IF G_PARTY_ID IS NOT NULL THEN
1495: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1496: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1497: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1498: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1499: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1500:

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

1507: l_sql := l_sql || 'AND '||l_where;
1508: l_interface_sql := l_interface_sql || 'AND '||l_where;
1509:
1510: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1511: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1512: l_sql := l_sql ||' ozf_resale_lines WHERE';
1513: l_sql := l_sql || l_where;
1514: l_interface_sql := l_interface_sql || l_where;
1515: END IF;

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

1508: l_interface_sql := l_interface_sql || 'AND '||l_where;
1509:
1510: ELSIF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1511: l_interface_sql := l_sql ||' ozf_resale_lines_int WHERE ';
1512: l_sql := l_sql ||' ozf_resale_lines WHERE';
1513: l_sql := l_sql || l_where;
1514: l_interface_sql := l_interface_sql || l_where;
1515: END IF;
1516: