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_BATCHES

Line 1083: ,ozf_resale_batches bat

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)
1087: UNION

Line 1090: ,ozf_resale_batches bat

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
1094: AND bat.resale_batch_id = map.resale_batch_id

Line 1113: ,ozf_resale_batches bat

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)
1117: UNION

Line 1120: ,ozf_resale_batches bat

1116: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1117: UNION
1118: SELECT COUNT(orig_system_agreement_name) pt_cnt
1119: FROM ozf_resale_adjustments lin
1120: ,ozf_resale_batches bat
1121: WHERE orig_system_agreement_name = cv_external_code
1122: AND bat.resale_batch_id = lin.resale_batch_id
1123: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;
1124:

Line 1135: ,ozf_resale_batches bat

1131: ,cv_party_id NUMBER
1132: ,cv_account_id NUMBER ) IS
1133: SELECT COUNT(orig_system_agreement_uom)
1134: FROM ozf_resale_adjustments lin
1135: ,ozf_resale_batches bat
1136: WHERE orig_system_agreement_uom = cv_external_code
1137: AND bat.resale_batch_id = lin.resale_batch_id
1138: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;
1139:

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 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 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: