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.

[Home] [Help]

APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_BATCHES

Line 1096: ,ozf_resale_batches bat

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

Line 1103: ,ozf_resale_batches bat

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

Line 1126: ,ozf_resale_batches bat

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

Line 1133: ,ozf_resale_batches bat

1129: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1130: UNION
1131: SELECT COUNT(orig_system_agreement_name) pt_cnt
1132: FROM ozf_resale_adjustments lin
1133: ,ozf_resale_batches bat
1134: WHERE orig_system_agreement_name = cv_external_code
1135: AND bat.resale_batch_id = lin.resale_batch_id
1136: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;
1137:

Line 1148: ,ozf_resale_batches bat

1144: ,cv_party_id NUMBER
1145: ,cv_account_id NUMBER ) IS
1146: SELECT COUNT(orig_system_agreement_uom)
1147: FROM ozf_resale_adjustments lin
1148: ,ozf_resale_batches bat
1149: WHERE orig_system_agreement_uom = cv_external_code
1150: AND bat.resale_batch_id = lin.resale_batch_id
1151: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;
1152:

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